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