FIXED – Rule “User account requirement for Farm administrator” failed
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.
Thanks for this ,I tried this ,it did not work untill I added the UserName in question to
Site Collection Administrators as explained http://www.justinkobel.com/post/2012/08/22/Intalling-PowerPivot-When-You-Aren%E2%80%99t-the-Original-Install-Account.aspx
.Thanks Spjeff for this documentation
Thanks for the comment Oluyemi! Always great to have more tech detail. I think I ran this as the farm account (who had SCA permission) so that might explain why it worked during my troubleshooting.
Thanks Oluyemi, your comment saved me from lots of frustration. Adding the user name to Central Admin Site Collection Administrators fixed the issue for me.