“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:

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 …

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:

in which case you should be in business.

Good luck.

Cheers

Dave Mc

6 responses

Wolfgang Grinfeld

May 10, 2012 at 11:56 am

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

Reply
Sunny Singh

May 30, 2012 at 5:48 am

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

Reply
Nauman

January 21, 2013 at 10:47 am

yup it works for me too.

Reply
Eric Fang

July 12, 2013 at 2:52 pm

Nice post!

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

Reply
Kuifie

August 5, 2013 at 11:25 am

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.

Reply
Mohammed

September 20, 2013 at 7:17 pm

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

Reply

The Blog

Dave Mc muses about history, travel, writing, coaching, astronomy, technology and life, family and the world around us. You may agree with his opinions, you may not, that’s life …