Thursday 6 March 2014

SharePoint 2013 PowerPivot Configuration Tool: the user is not a farm administrator

Got this error while configuring the PowerPivot Configuration Tool  on the Development environment using a Developers account setup with farm account permissions

SharePoint 2013 PowerPivot Configuration Tool  the user is not a farm administrator

It was  quite bizarre the Developer's account had all the required rights on SQL Server , Local Admin on the box and Part of Farm Admin Group.

After further research tried running the PowerPivot Configuration Tool using Farm Account it didn't give any errors. Found that you need to be a Site Collection Administrator of Central Admin in order to run the PowerPivot Configuration Tool successfully.

Performed the following steps to resolve this

Launch the Central Admin
Go the Site Settings  > Site Collection Administrators
Add the User Account you're using to run the PowerPivot Configuration Tool  as Site Collection Admin
Click Ok

This resolved the issue was able to run the PowerPivot Configuration Tool Successfully.