Analysis Services Error when installing Power Pivot

Fix found here and my situation summary written out below

You have already installed PowerPivot and gotten the “Could not load file or assembly” error above, then:

Make sure you do not install Power Pivot until Step B is done. If you did already, the do items 1 – 6

  1. Uninstall the PowerPivot instance of Analysis Services, this will also uninstall PowerPivot for SharePoint components.
  2. Reboot the machine
  3. Run scripts to re-enable PremiumSite feature. See http://powerpivotgeek.com/2010/06/14/uninstalling-powerpivot-does-what-arg/
  4. Reboot the machine
  5. Copy the setup100.exe.config file, as outlined in (B) above, to %ProgramFiles%\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2\x64
  6. Install PowerPivot for SharePoint.

B. If you have an RDBMS only instance(s) installed and are getting ready for a PowerPivot installation (“New Server” or “Existing Farm”): Save the following text to a file named setup100.exe.config (no .txt extension):

  • a. Save the following text to a file named setup100.exe.config (no .txt extension):

    <?xml version="1.0" encoding="utf-8" ?>
    <configuration>
      <runtime>
        <disableCachingBindingFailures enabled="1" />
      </runtime>
    </configuration>

  • b. Copy the file to the folder: %ProgramFiles%\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2\x64\ and install PowerPivot for SharePoint.
Advertisements