none
[Absolutely sick of PowerPivot... the product stinks!!!] Failed to find assembly Microsoft.AnalysisServices.SharePoint.Integration.EngineService

    Question

  • I am trying to install this product for last 2 days and everything which I have done so far has not worked.

    1) installed SP2010 and then ran PowerPivot install. It gave an error

    Failed to find assembly Microsoft.AnalysisServices.SharePoint.Integration.EngineService

    I googled on the subject and found the following articles

    1) http://msdn.microsoft.com/en-us/library/ff487868.aspx

    2) http://powerpivotgeek.com/2010/06/14/installation-failure-could-not-load-file-or-assembly-microsoft-analysisservices-sharepoint-integration-dll/

     

    Both these articles do not solve the problem

    Now I gave up on this product because it looks like an unfinished product to me. So I removed powerpivot and removed my farm and then I am trying to configure a fresh farm.

    And again this error is coming up even when PowerPivot is un-installed and I am trying to go back to SP2010 the way it was before PowerPivot was installed.

    Now after removing all content databases and config database and also removing my server from the farm. when i try to configure  a fresh farm I get error

     

    This is truely a product which sucks!!

     

    1) it does not install properly.

    2) it breaks the sharepoint farm on which it is installed.

    Why did MS release this product if The EngineService was not finished and can never be found by the isntaller???

    Tuesday, August 16, 2011 7:40 PM

Answers

  • I was finally able to resole the problem. Apparently the uninstallation of Powerpivot is broken (Whoa... the product is broken and the uninstall is also broken)

    It switches off certain features of SharePoint even after being removed.

    I removed everying (SharePoint and PowerPivot) then rebooted my machine

    then ran the PowerShell script posted here

    http://support.microsoft.com/kb/2261512

    and reboot my machine.

    Then I created a new setup100.config file as described here

    http://support.microsoft.com/kb/2261507

    Then I re-ran the setup and everything worked fine.

     

    but still MS could have done a better job at the installation of this product. It has the feel of a beta/ctp product ... RTM products should not require so much gymnastics for a simple installation.

     

    • Marked as answer by MSDN Student Monday, August 29, 2011 10:15 AM
    Monday, August 29, 2011 10:15 AM

All replies

  • The guide here is useless to

    http://powerpivotgeek.com/server-installation/single-server-install-rtm/

     

    Before when you use the "New Farm" option is tries to co-locate the SQL databases on the same box... something which I don't want.

    My database server is remote.

    Tuesday, August 16, 2011 7:52 PM
  •  

     

    Hello MSDN Student,

     

    What is the SharePoint farm topology that you are trying to deploy? Is it all in one box? What SQL databases you have mentioned?

     

    To install New Farm, it will install everything in a single box, including a relational SQL database (default instance). Also, for New Farm option SharePoint must not be configured yet (the Setup will do that for you). If this is not something you want to do (in case the SharePoint farm is already up and running), you should chose Existing Farm option. And for that there is another tutorial you may find handy to follow instead:

     

    http://download.microsoft.com/download/A/D/6/AD67E0F2-9E55-4E78-9155-E3AD7FF671CA/PowerPivot%20-%20Existing%20Farm%20Installation.docx

     

    Hope that helps,

    Mariano


    Mariano Teixeira Neto Analysis Services SQL Server BI Microsoft Corp.
    Tuesday, August 16, 2011 8:25 PM
  • I am building a 2 server farm. I have followed the steps in this document and they do not help in solving the problem.
    Tuesday, August 16, 2011 10:25 PM
  • The document posted above is of no use. it doesn't solve the problem.

    I also found a bug for the exact same issue which MS has marked as solved. I saw that in the comments section people have posted that the bug is not solved in RTM software.

     

    Friday, August 19, 2011 1:44 PM
  • Hello MSDN Student,

     

     

    I'm sorry to hear you are still havining issues with it. Just so we can better address the problem, did you have already a SQL Server 2008 R2 instance running on the machine you were installing PowerPivot for SharePoint (so we can learn if it is the same root cause or a different thing)?

     

     

    Thanks,

    Mariano


    Mariano Teixeira Neto Analysis Services SQL Server BI Microsoft Corp.
    Friday, August 19, 2011 4:56 PM
  • I have a 2 server farm. 1 WFE and 1 SQL.

    I installed PowerPivot on WFE. So it did not have SQL Server 2008 R2 installed on it.

     

    Also, I have tried uninstalling both SharePoint and all SQL Components (which powerpivot install had put) and then retry... but it always fails with the above error message.

     

    Tuesday, August 23, 2011 7:48 AM
  • I was finally able to resole the problem. Apparently the uninstallation of Powerpivot is broken (Whoa... the product is broken and the uninstall is also broken)

    It switches off certain features of SharePoint even after being removed.

    I removed everying (SharePoint and PowerPivot) then rebooted my machine

    then ran the PowerShell script posted here

    http://support.microsoft.com/kb/2261512

    and reboot my machine.

    Then I created a new setup100.config file as described here

    http://support.microsoft.com/kb/2261507

    Then I re-ran the setup and everything worked fine.

     

    but still MS could have done a better job at the installation of this product. It has the feel of a beta/ctp product ... RTM products should not require so much gymnastics for a simple installation.

     

    • Marked as answer by MSDN Student Monday, August 29, 2011 10:15 AM
    Monday, August 29, 2011 10:15 AM