When installing PowerPivot on SharePoint 2010 you might see the below error. Behind the scenes several permissions are being verified, not just Farm Admin. In my case I also needed to grant SQL SYSADMIN permission to the user account performing the install. This error message is confusing because it can occur even if you are listed on Central Administration as a Farm Admin. So before you run “setup.exe” on the SQL CD, be sure to double check your permissions.
PowerPivot install account needs:
- Local Administrator
- Farm Administrator
- SQL sysadmin fixed role
Rule "User account requirement for Farm administrator " failed. The user is not a farm administrator.