SQL Server - SharePoint PowerPivot Error

SQL Server - SharePoint PowerPivot Error

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/5ae1b975-f9b8-4397-b6e8-6dd0a02e03f9/error-during-powerpivot-for-sharepoint-installation?forum=sqlkjpowerpointforsharepoint

Rule "User account requirement for Farm administrator" failed

SharePoint forums

 - 

SharePoint 2010 - Setup, Upgrade, Administration and Operations

Question

• 
  

  
  

  
  

  Hi,
  I'm trying to install the PowerPivot for SharePoint (SP 2010) following the instructions inhttp://msdn.microsoft.com/en-us/library/ee210616(SQL.105).aspx
  The problem is the following step:  "In Installation Rules, click Next."
  Image of error: http://yfrog.com/0rproblembzlj
  I'm administrator of everything. SharePoint, SQL Server, machine...
  
  

Reply

• In order to be able to install PowerPivot on SP farm you need to be an administrator on the SP farm. So you need to ask the person ‘A’, who installed the farm, to grant you administrative privileges on the farm. - User A adds you to the farm admins group through Central Admin -> Security -> Manage the farm administrators group. - User A adds you to the Site Collections Administrator Group. Central Admin -> Site Actions -> Permissions -> Site Collection Administrators. - User A adds you as dbo of the SharePoint config db  - User A adds you as dbo of the SharePoint AdminContent db  - You should be a machine admin on every machine in the farm. 


http://social.technet.microsoft.com/Forums/en-US/c97200c9-edf8-417c-a005-59cf9f35d7d8/rule-user-account-requirement-for-farm-administrator-failed?forum=sharepointadminprevious




Finding the Setup User Administrator account of a SharePoint Farm

Imagine, you are assigned a task to apply a Service Pack to an existing SharePoint farm, and as you know to apply the Service pack and run the SharePoint Products and Technologies Configuration Wizard properly you need to install it using the Setup User Administrator (Basically the user account which was used to install SharePoint). But there is no documentation and no one remembers which account was used to for the installation. So the quickest option way to find out would be go in Central Administration site
and
check the users in Farms Administrators group. But to your surprise there is a list of users out there and you really cannot figure it out which one is the setup user. There was a user who was stuck in similar situation on one of the forums out there.

To find the Setup User Administrator account is to check the Account under which the Central Admin Application pool is
running in IIS and also the Windows SharePoint Services Timer is running.

1. Central Admin Application pool Properties

2. Windows SharePoint Services Timer Service Properties

http://www.spjeff.com/2011/07/27/fixed-rule-user-account-requirement-for-farm-administrator-failed/

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.