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…
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…
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…
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…
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…
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…
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…
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…
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…