none
Re-Install Powerpivot for sharepoint - Rule "Single Instance Requirement" failed

    Question

  • Hello,

    I'm trying to re-install powerpivot for sharepoint but at the end of the setup I'm getting a Rule "Single Instance Requirement" failed.

    Her's the detail:

    ___________________________

     ASSPINoExistingIMBICheck

    Checks for an existing instance of SQL Server PowerPivot for SharePoint. You can have only one instance of PowerPivot for SharePoint on a computer.

    Failed

    PowerPivot for SharePoint is already installed on this computer. You cannot install a second instance.

    ______________________

     

    Actually instance of powerpivot running, I also tried to uninstall and re-install Analysis Services without success.

    Anyone know how I can fully cleanup Powerpivot for Sharepoint in order to re-install it?

    Thank you

    fyi : my machine is a win7 x64 with SQL 2008 R2

     

     

     

     

    Thursday, December 16, 2010 8:50 AM

Answers

  •  

     

    Hi BI_er_007,

     

    The thing is that this Setup rule verifies whether PowerPivot for SharePoint was previously installed in this box or not by getting this information from SharePoint. Despite you have uninstalled the Analysis Services\PowerPivot instance from this machine, you did not touch SharePoint. For SharePoint you very likely still have the SQL Services Analysis Services Service and the PowerPivot System Services.

     

    Here is how to uninstall the PowerPivot for SharePoint in details:

    http://msdn.microsoft.com/en-us/library/ff487866.aspx

     

    I hope that helps.

    Best,

    Mariano


    Mariano Teixeira Neto Analysis Services SQL Server BI Microsoft Corp.
    • Marked as answer by Christophe_BI Tuesday, December 21, 2010 1:43 PM
    Tuesday, December 21, 2010 4:14 AM

All replies

  •  

    Hi BI_er_007,

     

    Did you uninstall the AS instance in your box too? It looks like you didn't. Without uninstalling it you won't be able to install PowerPivot for SharePoint again, since it also installs the Analysis Services (powerpivot instance).

    Let me know if I can help you any further, ok?

    Best,

    Mariano


    Mariano Teixeira Neto Analysis Services SQL Server BI Microsoft Corp.
    Thursday, December 16, 2010 9:53 PM
  • Hi Mariano,

    What do you mean by "in your box"?

    My regular AS instance is still installed.

    Thx

    Friday, December 17, 2010 5:55 AM
  •  

     

    Hi Dave,

     

    I meant if you also uninstalled the SQL Server Analysis Services\PowerPivot instance from your server, or did you just uninstalled PowerPivot services and applications from the SharePoint farm?

    By regular AS you mean the AS that you had previouns installed through the SQL Server PowerPivot for SharePoint setup option?

    Thanks,

    Mariano


    Mariano Teixeira Neto Analysis Services SQL Server BI Microsoft Corp.
    Friday, December 17, 2010 11:32 AM
  • I only uninstall the SQL Server Analysis Services\PowerPivot.

    I didn't touch the sharepoint

    By regular AS I meant classic Analysis Services instance

    Thank you 

    Friday, December 17, 2010 11:36 AM
  •  

     

    Hi BI_er_007,

     

    The thing is that this Setup rule verifies whether PowerPivot for SharePoint was previously installed in this box or not by getting this information from SharePoint. Despite you have uninstalled the Analysis Services\PowerPivot instance from this machine, you did not touch SharePoint. For SharePoint you very likely still have the SQL Services Analysis Services Service and the PowerPivot System Services.

     

    Here is how to uninstall the PowerPivot for SharePoint in details:

    http://msdn.microsoft.com/en-us/library/ff487866.aspx

     

    I hope that helps.

    Best,

    Mariano


    Mariano Teixeira Neto Analysis Services SQL Server BI Microsoft Corp.
    • Marked as answer by Christophe_BI Tuesday, December 21, 2010 1:43 PM
    Tuesday, December 21, 2010 4:14 AM
  • Thx Mariano ;-)

    Actually I've to go to

    Central Administration \ System Settings  \ Manage farm solutions

    and retract and remove Powerpivot Solutions

    Thanks again!

    • Proposed as answer by Hikmer Tuesday, April 19, 2011 7:42 PM
    Tuesday, December 21, 2010 1:47 PM
  • Yes the Farm Solutions issue was casuing me issues too.   What a total pain to fix, wasted half my day from a botched install.

    Tuesday, April 19, 2011 7:46 PM