Thursday, September 12, 2013

Could not load file or assembly 'Microsoft.AnalysisServices.SharePoint.Integration

A lot of articles have been written about this particular issue. It seems like a really big issue with all the errors popping up everywhere, but in all honesty, it's bark is worse than its bite. I'll update this post later with a few online resources which I've found very useful while trying to solve this error.

The error usually goes something like this...

Error: Could not load file or assembly 'Microsoft.AnalysisServices.SharePoint.Integration, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
Option 1

Open up command prompt with elevated permissions and run this command

RD /S C:\Windows\Assembly\GAC_MSIL\Microsoft.AnalysisServices.SharePoint.Integration

In most cases you will get an Access Denied error. That is because w3wp.exe is holding onto the file. You will need to stop IIS and run the command again.

Option 2

1. After the installer fails disable the assembly cache viewer.
2. Go into the assembly and find the file Microsoft.AnalysisServices.SharePoint.Integration.dll
3. Copy this dll to the bootstrap location: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2\x64
4. Remove the Powerpivot instance from the Program and Features .. SQL Server 2008 R2 Uninstall
5. Enable the assembly cache viewer and copy the Microsoft.AnalysisServices.SharePoint.Integration.dll into the GAC.
6. Run the installation process again to install the PowerPivot instance.