Wednesday, 2 October 2013

Configuration of PowerPivot

Installing and configuration of PowerPivot on a SP2013 with SQL Server 2012 SP1. I got the following error-message when running the PowerPivot configuration tool:

"The user is not a farm administrator. please address the validation failures and try again"

I´m a farm administrator with my account that is used to configure PowerPivot. The solution to this was to add my account as a secondary owner to the CA site collection.

Wednesday, 29 May 2013

The DataSourceID of ‘TopNavigationMenu’ must be the ID of a control of type IHierarchicalDataSource. A control with ID ‘topSiteMap’ could not be found.

No differences in web.config or errors in the ULS. After a few minutes with ProcessMonitor I noticed "Access Denied" errors for "Microsoft.SharePoint.ApplicationPages.dll" in the "_app_bin" folder.

I was not part of the installation of this SharePoint server and couldn´t tell if some special configuration had been done to cause this.

To solve this I gave "Everyone" Full Control on the file.