How do I - Install PowerPivot into an EXISTING SharePoint 2010 farm

Written by Cornelius J. van Dyk

Friday, 25 June 2010 01:36

This one was a BEAR to work through. There’s not much out there for it and everywhere I turned it seems everyone else was either having the same problem OR suggestion we “start with a clean install”. Nice suggestion that last one. Almost like… try rebooting the computer… but I digress. So hopefully this guide will help some other poor soul save some time when they run into the same issue.

Due to a farm admin error during PowerPivot install that incorrectly claims that the current user is NOT a Farm Administrator, you’ll need to logon to your SharePoint server, using the SharePoint Admin Service account credentials.
Install the Microsoft Access Database Engine 2010 Redistributable.
Startup the SQL Server 2008 R2 installer in Admin mode:
Browse to the CD folder of the install media.
Right click “Setup.exe”.