“The user is not a farm administrator” : Configuring PowerPivot for SQL 2012 RC0

Configuring PowerPivot for SQL Server 2012 is a little different.  You now get a Configuration Tool for PowerPivot, rather like you get a Configuration Tool for Reporting Services.  The configuration tool can be reached from the Windows Start Menu as can be seen in Figure 1:

PowerPivot 2012 Configuration Wizard

Figure 1 : PowerPivot 2012 Configuration Wizard

You get asked to Configure or Repair PowerPivot for SharePoint next, but the validation doesn’t seem to pick up the fact that you are a Farm Administrator unless you are logged in as the account with which you actually installed and created the Central Administration of your SharePoint Farm.   So you get faced with the following dialog whether you are a Farm Admin or not …

User is not a Farm Administrator

Figure 2 : "User is not a Farm Administrator"

You can be God Admin on every box on the Internet and it won’t make any difference …  You’ll just have to log back in as the installation account and then try again.  You should see the following colorful “Eaxmining your system.” dialog:

Figure 3 : Examining Dialog

Figure 3 : Examining Dialog

in which case you should be in business.

Good luck.

Cheers

Dave Mc

Advertisements

About davemcmahon81
Software Developer & Architect, User Group Leader, Speaker, Writer, Blogger, Occasional Guitarist, Man-made Global Warming Sceptic, Climate Change Believer, General Optimist but most of all proud Husband and Dad ...

6 Responses to “The user is not a farm administrator” : Configuring PowerPivot for SQL 2012 RC0

  1. Wolfgang Grinfeld says:

    “… User is not a Farm admin ….” : Alternatively, change the primary administrator of the Central Admin Site collection

  2. Sunny Singh says:

    Yes. I struggled with this too, setting the setup account as primary administrator of the Central Admin site works the trick.

  3. Nauman says:

    yup it works for me too.

  4. Eric Fang says:

    Nice post!

    I think just need to add the current user account to CA site collection administrators user group.

  5. Kuifie says:

    Thank you for the above. The more I use SharePoint (Scare Point), the more I realised that it is too complex for Microsoft to handle. There are so much wonderful features but it is overly complex to get everthing to work.

  6. Mohammed says:

    yup…changed primary admin account and it worked! thanks.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: