Problems getting PowerPivot for SharePoint configured and running

Question

Hi,

I've installed SQL 2012 RC0 and is trying to configure PowerPivot for sharepoint. I've followed the installation instructions on technet and provisioned the service application. However, when i try to access it I get this error in the ULS log...

Also,

I don't see SQL Server Analysis Services and SQL Server PowerPivot System Service in my list of services.

 

12/05/2011 14:39:51.40 	w3wp.exe (0x1EC4)                       	0x219C	SharePoint Foundation         	Runtime                       	tkau	Unexpected	Microsoft.AnalysisServices.SharePoint.Integration.Redirector.RedirectorException: The PowerPivot service application could not connect to the Analysis Services instance.    at Microsoft.AnalysisServices.SharePoint.Integration.GeminiServiceApplicationProxy.ExecuteWithRetriesOnDiffEndpoints(String operationName, CodeToRunOnChannel codeBlock, Int32 numOfRetries)     at Microsoft.AnalysisServices.SharePoint.Integration.GeminiServiceApplicationProxy.GetLastDataRefreshFailedRuns(Int32 days, Int32 topCount)     at Microsoft.AnalysisServices.SharePoint.Integration.DataRefreshFailureWebPart.GetDataTable()     at Microsoft.AnalysisServices.SharePoint.Integration.DataRefreshFailureWebPart.CreateChildControls()     at System.Web.UI.Control.EnsureChildControls()     at System.Web.UI.Control.PreRenderRe...	7f17304c-c53b-4373-94e3-eb1cf270908b
12/05/2011 14:39:51.40*	w3wp.exe (0x1EC4)                       	0x219C	SharePoint Foundation         	Runtime                       	tkau	Unexpected	...cursiveInternal()     at System.Web.UI.Control.PreRenderRecursiveInternal()     at System.Web.UI.Control.PreRenderRecursiveInternal()     at System.Web.UI.Control.PreRenderRecursiveInternal()     at System.Web.UI.Control.PreRenderRecursiveInternal()     at System.Web.UI.Control.PreRenderRecursiveInternal()     at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)	7f17304c-c53b-4373-94e3-eb1cf270908b
12/05/2011 14:39:51.67 	w3wp.exe (0x1EC4)                       	0x219C	SharePoint Foundation         	Monitoring                    	b4ly	Medium  	Leaving Monitored Scope (Request (GET:http://lapmpo15:21745/ServiceAppDashboard.aspx?Id=6892532b-4e71-46a6-9042-9fe8e5fb76a2&RootFolder=%2FPowerPivot%20Management%2F6892532b-4e71-46a6-9042-9fe8e5fb76a2%2F1033)). Execution Time=8215.12052371638	7f17304c-c53b-4373-94e3-eb1cf270908b

 

Running the Powerpivot configuration tool I get a dialog with the following error:

 

---------------------------
System Validation
---------------------------
Current Analysis Services service account: DOMAIN\SPSqlTest

Analysis Services service account must be the same for all instances in the farm. Change you service properties to log on using account: NT AUTHORITY\LOCAL SERVICE.


Plsease address the validation failures and try again. 
---------------------------
OK   
---------------------------

 

I'm also getting this error in the event log:

 

"There are no instances of the SQL Server PowerPivot Service Application started on any server in this farm. Ensure that at least one instance is started on an application server in the farm using the Services on Server page in Central Administration."

 

I've installed SQL PowerPivot on LOCALHOST\POWERPIVOT Instance and everything else on the default instance (Analysis Services as tabular).

Any suggestions would be much appreciated. This is running on a Windows 7 Enterprise.

 

Thanks!

 

Answer 1

Hi mortenbpost,

Firstly, for SQL Server Analysis Services, you must specify a domain user account. Do not specify a built-in account. Domain accounts are required for managing the Analysis Services service account as a managed account in SharePoint Central administration.

Secondly, Analysis Services can be installed in one of three server modes: Multidimensional and Data Mining (default), PowerPivot for SharePoint, and Tabular. To your scenario of integrating PowerPivot into SharePoint, it should be PowerPivot for SharePoint mode not Tabular, Tabular mode is just store the database for PowerPivot or Power View. So I would recommend install the Analysis Services intance in PowerPivot for SharePoint mode along with installing PowerPivot, you can refer to this Install PowerPivot for SharePoint

For more information about install PowerPivot please see: http://msdn.microsoft.com/en-us/library/hh231687(v=SQL.110).aspx

Thanks,
Challen Fu

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 2

Thanks for you reply. I'm using only domain accounts for the setup. Also I've install powerpivot for sharepoint on the localhost\powerpivot instance. 

I got it working by reinstalling windows and doing the exact same as before.

- i've previously had ctp3 installed which must be why it didn't work.

 

Thanks anyways :)

Answer 3

Hi mortenbpost,

The environment setup is as follows:

1. Server-1 - Domain Controller

2. Server-1 - Server containing SharePoint 2010 SP1, 2012 RC0 with PowerPivot. I'm using BIAdmin domain account as the service account for SSAS.

After installing SharePoint 2010 SP1 and 2012 RC0 in PowerPivot for SharePoint mode this i'm getting an error when i tried to configure PowerPivot:

Failure while running action: Install PowerPivot Central Administration Feature

08/12/11 05:38:43:7476 High: Failure

08/12/11 05:38:43:7476 High: Object '/9c8e52bc_9151_42aa_8595_2777131c0c30/8wd1xwqpjbsvty+ag+pguh4v_5.rem' has been disconnected or does not exist at the server.

08/12/11 05:38:44:3816 High: Exception while executing action InstallPowerPivotAdminFeature: Object '/9c8e52bc_9151_42aa_8595_2777131c0c30/8wd1xwqpjbsvty+ag+pguh4v_5.rem' has been disconnected or does not exist at the server.

When I try to re-open PowerPivot configuration tool i'm facing the same issue highlighted in this post. For completeness sake the error is as follows:

Current Analysis Services service account: BILABS\BIAdmin Analysis Services service account must be the same for all instances in the farm. Change you service properties to log on using account: NT AUTHORITY\LOCAL SERVICE. Plsease address the validation failures and try again.

Any inputs from your side to resolve this issue?

-Samrat

 

Answer 4

No, I gave up trying to find out what that meant. Notice the spelling error in please... I'm guessing there still some way to go before that works like it should. Hopefully they clean this randomness up before the final release.

Try installing sharepoint but don't run the configuration. After that you should run the configuration tool and let it set everything up for you. Even the websites. That might work for you.

Answer 5

Strangely this issue is persistent when i install 2012 rc0 with Powerpivot on a VM without running windows update on VM with windows server 2008 r2 sp1 installed. Some proxy restriction hence i cant do windows update. After about 7 tries i hav lost all patience.

For evaluation purpose i installed 2012 rc0 on an updated copy of windows 2008 r2 on a proxy free network and things work fine when i do a complete install. So for powerview im going to continue to use this system.

In addition to misspelled word please,  the dialog box mentions 'Change you ' in the line 'Change you service properties to log on using account: NT AUTHORITY\LOCAL SERVICE.'.

Answer 6

I have exactly the same error but I'm not able to reinstall sharepoint or OS. There are more people working on SPS. I didn't install RC0 on CTP3. I was clean RC0 installation.

Thank you for any advice.

M.

---

Martin

Answer 7

I'm also getting this error ...

"Analysis Services service account must be the same for all instances in the farm. Change you service properties to log on using account: NT AUTHORITY\LOCAL SERVICE."

If I do change them all to Local Service it still complains!

I've re-installed SQL Server. What's next? Re-install Windows?

OUCH!

Answer 8

I'm also getting this error ...

"Analysis Services service account must be the same for all instances in the farm. Change you service properties to log on using account: NT AUTHORITY\LOCAL SERVICE."

If I do change them all to Local Service it still complains!

I've re-installed SQL Server. What's next? Re-install Windows?

OUCH!

If you can, let the tool configure your entire farm.

Answer 9

The following Solution worked for me. Try this. 1. Goto SharePoint 2010 - Central Administration 2. Goto Security -> Configure Service Accounts 3. In the Credentials window - In the dropdown Select "Windows Service - SQL Server Analysis Services". It will display the corresponding user.In this case it will show "Local Service" 4. Select the Administrator userid. 5. Check the SSAS Service also running as a Administrator. Now run the Power Pivot Configuration tool.

Answer 10

Thanks. This helped

Answer 11

Changing the account in Central Administration enabled me to proceed with the configuration.

I had performed a side-by-side install of SQL Server 2012 on my development machine and was migrating over database.  The PowerPivot install starting reporting that the service did not exist so I tried to re-install and got into this error trap.

Answer 12

That did the trick - nice find.

Answer 13

The following Solution worked for me. Try this. 1. Goto SharePoint 2010 - Central Administration 2. Goto Security -> Configure Service Accounts 3. In the Credentials window - In the dropdown Select "Windows Service - SQL Server Analysis Services". It will display the corresponding user.In this case it will show "Local Service" 4. Select the Administrator userid. 5. Check the SSAS Service also running as a Administrator. Now run the Power Pivot Configuration tool.

I am getting a validation failure error in PowerPivot Configuration Tool.  PowerPivot installation was successful.

I can't find Windows Service - SQL Server Analysis Services on The Configure Services drop down.

Any idea?

Answer 14

Hi Samrat

I see you had problems installing on a VM machine. Did you ever get this resolved?

I'm trying to install powerpivot for sharepoint via the sal server 2012 wizard.

I get the this error when trying to specify an account for SSAS:

The credentials you provided for analysis services service are invalid. To continue, provide a valid account and password for analysis services service.

I