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…
SharePoint 2013 – "This page can’t be displayed" when clicking on an app
I have just created an App Catalog in SharePoint 2013 but after adding an app from the SharePoint store I tried to configure it and received the following message: This page can’t be displayed It turned out that I had…
SharePoint 2013 – AutoSPInstaller hangs at "Creating Metadata Service Application…"
I have noticed several times when using AutoSPInstaller that it hangs at “Creating Metadata Service Application”. So far I haven’t managed to work out why this happens, but the only workaround I have found is to close the PowerShell window…
PowerShell script to report the last modified date for all sites within a site collection
In response to a post on the Microsoft TechNet Forums I wrote the following script to report the last modified date for all sites within a site collection using the Get-SPSite and Get-SPWeb PowerShell cmdlets. $SiteCollection = Get-SPSite https://yoursite.yourdomain.local ForEach($Site in…
Loading ...