Prevent site collection administrators from upgrading site collections
If you are upgrading from SharePoint 2010 to SharePoint 2013, and you need to prevent site collection administrators from upgrading site collections, then you can disable Self Service Upgrades using the Get-SPSite cmdlet: $portal = Get-SPSite “http://portal.lab.local” $portal.AllowSelfServiceUpgrade = False…
Ensure a purchased app is available in all site collections
I have purchased an app and need to make sure it s available in all site collections within a web application. Firstly I import the app package using the Import-SPAppPackage cmdlet: $spapp = Import-SPAppPackage -Path C:\MyApp.spapp -Site http://portal.lab.local -Source Marketplace Then…
PowerShell script to list sites that have a specified feature enabled
The following PowerShell script will enumerate all sites within a Site Collection and report on where a particular feature has been enabled using the Get-SPWeb cmdlet. In the example I am reporting on the SharePoint Server Enterprise Site Features feature…
SharePoint 2013 – create an external content type for SQL Server
I am creating an external content type to display records from an SQL table in a SharePoint list, using a target application in the Secure Store for authentication. I will do this using SharePoint Designer 2013. At a minimum, I…
Access denied by Business Data Connectivity
While creating an external content type in SharePoint Designer 2013 the following error was displayed when adding a connection to an SQL server using an impersonated custom identity: Access denied by Business Data Connectivity This occurred because the user does…
SharePoint 2013 – Configure the Secure Store and create a Target Application
I am configuring a Secure Store and creating a Target Application to store credentials for an external SQL database using SQL authentication. This is done in a few simple steps using Central Administration: Register a managed account to run the…
SharePoint 2013 – Dependency feature ‘PPSSiteCollectionMaster’ for feature ‘PPSSiteMaster’ is not activated at this scope
I have just tried to create a new Business Intelligence Center site within SharePoint 2013 and received the following error: Dependency feature ‘PPSSiteCollectionMaster’ (id: a1cb5b7f-e5e9-421b-915f-bf519b0760ef) for feature ‘PPSSiteMaster’ (id: 0b07a7f4-8bb8-4ec0-a31b-115732b9584d) is not activated at this scope. This was easily fixed…
SharePoint 2013 – Request an upgrade evaluation site collection
If you have a site collection that is in SharePoint 2010 mode you can create a temporary upgrade evaluation site collection using the Request-SPUpgradeEvaluationSite cmdlet. Here is an example of how this would look: Request-SPUpgradeEvaluationSite -Identity http://portal.lab.local/sites/sp2010site By default the…
SharePoint 2013 – prevent users from purchasing or installing apps from the SharePoint store
If you have created an app catalog, but don’t want users to be able to purchase or install apps from the SharePoint Store, this can be configured in a few simple steps: Log in to Central Administration as a farm…
We’re having a problem opening this location in File Explorer
When clicking the Open with Explorer button in the library ribbon, the following message is displayed: We’re having a problem opening this location in File Explorer. Add this location to your Trusted Sites list and try again. Sometimes adding the URL…