PowerPivot for SharePoint Installation Hiccup

I was trying to install PowerPivot for SharePoint the other day in an existing SharePoint farm and it kept failing with the following error:

“cannot load file or assembly ‘Microsoft.AnalysisServices.SharePoint.Intergration, Version = 10.0.0.0, Culture=neutral. PublicKeyToken= 89845dcd8080cc91’ or one of its dependencies. The system cannot find the file specified.”

It turns out that the Installation Configuration .ini file stores a port number for the Farms SharePoint Central Admin site. Not sure how it comes up with the port number, but modifying the entry in the .ini to correspond to your existing Central Admin site, prior to completing the istall to  seems to solve the issue.

The ini file is found at C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\YYYYMMDD_1234567\ConfigurationFile.ini

Advertisements

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