SharePointSupport

$site = Get-SPSite "http://yoursite" foreach ($web in $site.AllWebs) { $web | Select-Object -Property Title,Url,WebTemplate } $site.Dispose()

This article explains about Excel related issue in our SharePoint 2013 Environment. Whenever user tries to open excel files uploaded in document library, it launches browser to open the file and then displays below error- " We’re sorry. We ran into a problem completing your request. Please try that again in few minutes." Also see below screenshot- As part of issue analysis, following checks were performed- 1.) Check if Excel Services is running. ( This was running in our case. ) Open Central Administration -> System Settings -> Manage Services on Server -> Excel Calculation Service -> Started 2.) Check if Excel Service Application is associated to Web Application in question. ( This was configured in our case. ) Open Central Administration -> Application Management -> Manage Web Applications -> Select Web Application -> Select Configure Service Associations 3.) Check if Trusted File Location is configured for Excel Service

This article is related to below post where user reported missing ribbon issue after migration from SharePoint 2007 to 2013 version. https://social.technet.microsoft.com/Forums/en-US/628b9f7b-b1e7-4bb1-b01d-fcb11b252862/ribbons-missing-after-migration Scenario: Ribbon not visible on SharePoint List/Library page load. Mostly reported after site migration from 2007 to 2010/2013 version. Also if you have added a content editor web part on this page. Cause: When content editor web part is added to standard list/library pages, classification of page changes from List View page to Application page. Solution: First of all, if you are experiencing this issue after migration, perform below checks- Check if this issue appears for existing/new list/library pages. Is it happening for all lists/libraries If item in a list/library is selected, ribbon appears? Any customization  like Content Editor Web Part or JavaScript  code added on that page. Now if you hav

Background: I wanted to see all users who have access to the SharePoint site and belongs to which SharePoint group. Solution: Below SharePoint powershell script helps me to get list of users group wise- $site = Get-SPSite <Provide Site Collection URL here> $web = $site.OpenWeb() $groups = $web.sitegroups foreach ($grp in $groups) {      "Group: " + $grp.name;      $groupName = $grp.name      write-host "Group: " $groupName   -foregroundcolor green      foreach ($user in $grp.users) {              "User: " + $user.name              write-host "User " $user.UserLogin   -foregroundcolor red      } } Usage: Navigate to Script location and type below command- GetUsers.ps1 This will show output on screen. Navigate to Script location and type below command- GetUsers.ps1 | Out-File C:\Output.csv This will generate output as csv file. " C:\Output.csv " is

You can control which mode (2010 or 2013, or both) can be used when a user creates a site collection. The CompatibilityRange property on a web application controls the site modes available for a web application. You can view or change the settings for CompatibilityRange by using Windows PowerShell. check the following and let me know if helpful http://technet.microsoft.com/en-us/library/jj219599(v=office.15).aspx http://technet.microsoft.com/en-us/library/ff191199(v=office.15).aspx http://technet.microsoft.com/en-us/library/jj219650(v=office.15).aspx If you upgrade from SharePoint Server 2010 to SharePoint Server 2013, there are special considerations for My Sites. (My Sites are not available in SharePoint Foundation 2013.) Make sure that you upgrade the My Site Host site collection before you allow users to access their individual My Sites in SharePoint Server 2013. This makes sure that the server software and database changes are complete so that users ca

SharePoint 2010 and 2013 is having software boundary that we can't upload file bigger than 2 GB, so what if we have bigger files? To handle large files that are bigger than 2 GB there are few options you have: Use software to split files and then upload them and when you download them you will use the software to merge them again, there are available software to do the following Use File Share servers and from SharePoint create view to point to those file share servers. Upload files to cloud and inside SharePoint just add links to refer to those sites.

Workflow Manager is an added value to the SharePoint 2013, in the previous versions workflow was part of the SharePoint on SharePoint 2013 there are 2 flavors you can use when developing workflows the first one is the SharePoint 2010 workflow and the second and new one is the new workflow manager which is now a separate component, when you install the new workflow manager it will allow to create SharePoint 2013 workflows. The Architecture of the Workflow Manager depends on several separate databases to save the workflows so now the workflows are stored on those separate databases and not on the content databases so important in any backup and restore to make sure that all those workflows are backed up in case restoration is needed and while restoring there are important steps and scripts that needs to run in certain order to restore the workflow farm correctly. I will be walking through the steps to restore the workflow farms and the scripts used can be found in this l

To Migrate SharePoint DBs from SQL Server to another either same version or to a new version (2008 to 2008 or 2008 to 2012) you can follow the following steps: Stop all SharePoint and IIS Related Services. Stop IIS. Detach all related SQL Server databases. Configuration database Central Administration content database Content databases Service application databases   Move all database files (.mdf, .ldf, and .ndf) to the new server. Set up same user permissions on the new SQL server. Attach your databases to the new SQL Server. Verify ports in your new SQL server. Go to your SharePoint server and create your SQL Server Alias. Start all your SharePoint services.

Microsoft has introduced new Workflow engine and concept with SharePoint 2013 called Workflow Manager. The SharePoint 2013 Workflow platform uses the new Workflow Manager service. Workflow Manager is built on top of Windows Workflow Foundation. Windows Workflow Foundation is part of the .NET Framework 4.5. Workflow Manager is a separate download and must be configured to communicate with the SharePoint Server 2013 farm. In several cases your environment is secured and not accessing the internet and you want to install the workflow manager so in the following steps I am going to explain how to do that so you can install Workflow Manager offline to server(s) not connected to the internet. Download the web platform installer  http://download.microsoft.com/download/C/F/F/CFF3A0B8-99D4-41A2-AE1A-496C08BEB904/WebPlatformInstaller_amd64_en-US.msi and install it on a machine with internet access Run the following commands as administrator from command prom

Introduction One of the feature updates of the   March 2013 Public Update   for SharePoint 2013 enables you to use multiple app domains in SharePoint 2013 environments with alternate access mapping or host-header web application configurations. Microsoft introduced a new concept with SharePoint 2013 and Office 365 to extend the out of the box functionality instead of the normal approach of farm solutions now you can add apps (add ins) through Java script code or using .net and hosting apps outside SharePoint environment without need to go and deploy code into SharePoint which increase the  re-usability , enhance the security and assure that SharePoint farm stability and code isolation. To have apps working you need to configure App Domain which is a corner stone to have apps working, at some cases you will need to have more than one app domain configured so I am going through this topic in the few lines. Why we need multiple App Domains? You could use app

Here we go, it’s been a long time I didn’t publish an article which consist of hardcore troubleshooting! Yes, you are correct. It took some time to resolve but finally the issue has been resolved. This time it’s regarding problem occurring while ‘save site as template’ and how we found the culprit.  Problem description:- User has raised the problem ticket by mentioning “facing problem while saving the site as template”, additionally the templates are getting saved in the solution gallery but not able to activate it also.   Error message:- An unexpected error has occurred. Troubleshoot issues with Microsoft SharePoint Foundation. Correlation ID: acd95f50-4049-4625-9682-aa93aded118f   Troubleshooting done:- Further debugging in the SP ULS logs and we found some strange facts which are based on event receivers- please refer below-   SPSolutionExporter: Microsoft.SharePoint.SPException: Feature definition with Id 77658379-50ff-4e1e-a431-5652bee07a87 failed

Project Server 2010 Error Codes Project Server 2013 error codes

In SharePoint 2013, some service applications can be shared across server farms. By publishing a service application, you can optimize resources, avoid redundancy, and provide enterprise-wide services without installing a dedicated enterprise services farm. You can publish the following service applications in a SharePoint 2013 farm: Business Data Connectivity Machine Translation Managed Metadata User Profile Search Secure Store Additionally, a SharePoint 2010 farm can consume services from a SharePoint 2013 Server farm. This allows for upgrade of multi-farm environments in which a farm hosting service applications is upgraded first. In this scenario, the service applications and features that the SharePoint 2010 farm experiences are limited to those that are available in SharePoint 2010. For example, a SharePoint 2010 farm cannot consume the Machine Translation service application from a SharePoint Server 2013 farm and does not benefit from the new features of the User Prof

* SQL Server provides parallel queries to optimize query execution and index operations for computers that have m ore than one microprocessor (CPU) . Because SQL Server can perform a query or index operation in parallel by using several operating system threads, the operation can be completed quickly and efficiently. * During query optimization, SQL Server looks for queries or index operations that might benefit from parallel execution. * For these queries, SQL Server inserts exchange operators into the query execution plan to prepare the query for parallel execution .  * An exchange operator is an operator in a query execution plan that provides process management, data redistribution, and flow control . The exchange operator includes the Distribute Streams , Repartition Streams , and Gather Streams logical operators as subtypes, one or more of which can appear in the Show plan output of a query plan for a parallel query. * After exchange operators are inserted, the resul

This error "The Managed Metadata Service or Connection is currently not available. The Application Pool or Managed Metadata Web Service may not have been started. Please Contact your Administrator." appears with various possible ways. I have tried googling and everybody has given a solution to provide permission to Managed Metadata Service Application. But, this didn't fix my issue. I have looked at the ULS logs, it gives me access error as below. Exception occured while connecting to WCF endpoint: System.ServiceModel.Security.SecurityAccessDeniedException: Access is denied.    Server stack trace:   The below are possible solutions for this issue. Solution 1:  Check your IIS and check IUSR is added in Anonymous Authentication. Here are the steps. Open the IIS and click on ServerName in left pane. Now Click on Authentication in middle pane as shown in below screenshot. Right Click on Anonymous Authentication and select Edit option. Click on Specific