Configuration Failed – Failed to call GetTypes on assembly Microsoft.AnalysisServices.SPAddin


I was at a client recently and was trying to add a new SharePoint Server to the farm, and everything went well until I tried to run the SharePoint Products Configuration Wizard. The error was:

Task configdb has failed with an unknown exception Exception: Microsoft.SharePoint.Upgrade.SPUpgradeException: Failed to call GetTypes on assembly Microsoft.AnalysisServices.SPAddin, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91. Could not load file or assembly ‘Microsoft.AnalysisServices.SPClient, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91’ or one of its dependencies. The system cannot find the file specified.


The problem is that the rest of the farm had the PowerPivot enabled, and therefore the PowerPivot Addin is required. Unfortunately, This Add-in is not verified at the begging of the SharePoint Products Configuration Wizard standard check, so that is why you get to this error. A recommended best practice is to install spPowerPivot.msi on all servers in the SharePoint farm for configuration consistency, including application servers and web-front end servers. The installer package includes the Analysis Services data providers as well as the PowerPivot for SharePoint 2013 configuration tool. To fix the problem, simply download the installer file from Microsoft Download Center: Microsoft® SQL Server® 2014 PowerPivot for Microsoft SharePoint®, run it on your server and then re-run the SharePoint Products Configuration Wizard. Everything should work perfectly!

Drop a comment if this helped!

Leave a comment and don’t forget to like the Absolute SharePoint Blog Page  on Facebook and to follow me on Twitter here  for the latest news and technical articles on SharePoint.  Also, don’t forget to check out SharePoint Community.Net for more great SharePoint Content.

Previous Post
SharePoint 2013 SSRS – The remote server returned an error: (500) Internal Server Error
Next Post
Easily Compare Office 365 Plans


  • April 8, 2015 at 2:32 am

    Thank you, real world scenario this is common to see, thanks for posting detail, it also saves time not installing powerpivot using sql server installation disk.

  • April 13, 2015 at 8:30 am

    Thanks a life saver

  • October 16, 2015 at 10:20 am

    I’m still getting the error after running the sppowerpivot.msi on the server that I am adding to my far. Do I run the configuration tool?

    • October 17, 2015 at 12:27 am

      Yes, you need to run the config wizard!

      • October 18, 2015 at 6:26 am

        It is still failing…how do I run the PowerPivot configuration tool on the new server if I haven’t successfully run PSConfig to configuration SP on it for the first time? The server that is currently in the farm has PowerPivot and SP already configured and everything is running fine.

  • December 1, 2015 at 11:09 am

    Same issue here – I believe this is directly causing the OWSTIMER.EXE to fail. I’ll feedback on progress as I’m currently installing Microsoft® SQL Server® 2014 PowerPivot for Microsoft SharePoint®, I can;t run the config wizard because the solutions won’t install due to the Timer Service not running

  • December 28, 2015 at 12:47 pm

    I fixed it by installing PowerPivot 2012 not 2014.

  • February 3, 2016 at 7:49 am

    Yes this helped, but we have just selected sharepoint powerpivot while installing this msi


  • March 24, 2017 at 1:17 am

    You my friend are a Legend.


  • April 19, 2017 at 10:52 am

    When you read the answer you cant help but hit your head on the wall a few times! Thank you for this…


Leave a Reply

15 49.0138 8.38624 1 0 4000 1 300 1