PowerPivot: Troubleshooting Installation Problems

Applies to SQL Server 2008 R2 versions of PowerPivot for Excel and PowerPivot for SharePoint.

This article is a collection of links to existing blog posts, forum threads and documentation. Check back again for additional tips and techniques that are currently being developed, or add your own solutions or links to this page.

Troubleshooting PowerPivot/SharePoint Setup

Posted on the forum in December 2009. This is an old post, but still useful in terms of log file location and general purpose information on how to get started.

http://social.msdn.microsoft.com/Forums/en-US/sqlkjpowerpointforsharepoint/thread/dd119dca-961b-4e8f-83a0-bba5c9ef81df

How to install PowerPivot for Excel and list of know issues Posted in November 2009. Again, an older post, but the setup issues documented in this post remain the ones that still occur today. Worth a look if you are having trouble installing the client.

http://powerpivot-info.com/post/77-how-to-install-powerpivot-for-excel-and-list-of-know-issues

Analysis Services Error when installing Power Pivot. Posted in January 2011. Provides a step by step solution to the error Installation failure: “Could not load file or assembly ‘Microsoft.AnalysisServices.SharePoint.Integration.dll’ explained on the powerpivotgeek site. Steps and citations in the following link.

http://jimecox.wordpress.com/2011/01/23/analysis-services-error-when-installing-power-pivot/