locked
Installing Powerpivot for Sharepoint on SQL 2008 R2 Developer edition RRS feed

  • Question

  • Hi,

    all posts and official Microsoft pages on PowerPivot for Sharepoint states the SQL Server 2008 R2 Developer edition is a valid edition to install to. (http://msdn.microsoft.com/en-us/library/ee210616.aspx)

    However, I cannot see Powerpivot for Sharepoint as an option to choose in SQL setup wizard step "Setup role" (step 2.11) as indicated by the article above.

    Have someone any information on this? Is it feasible to do or is MS prereqs wrong? Please.

    BR,

    Owe

    Tuesday, October 25, 2011 11:06 AM

Answers

  • Hello Owe,

     

     

    PowerPivot for SharePoint is only available on SQL Server 2008 R2 Datacenter and Enterprise editions.

     

    You can compare the difference in SQL Server 2008 R2 flavors here:

     

    http://www.microsoft.com/sqlserver/en/us/product-info/compare.aspx

     

    I hope that helps.

     

    Best,

    Mariano


    Mariano Teixeira Neto Analysis Services SQL Server BI Microsoft Corp.
    • Marked as answer by owe Wednesday, October 26, 2011 6:38 AM
    Tuesday, October 25, 2011 5:45 PM

All replies

  • Hello Owe,

     

     

    PowerPivot for SharePoint is only available on SQL Server 2008 R2 Datacenter and Enterprise editions.

     

    You can compare the difference in SQL Server 2008 R2 flavors here:

     

    http://www.microsoft.com/sqlserver/en/us/product-info/compare.aspx

     

    I hope that helps.

     

    Best,

    Mariano


    Mariano Teixeira Neto Analysis Services SQL Server BI Microsoft Corp.
    • Marked as answer by owe Wednesday, October 26, 2011 6:38 AM
    Tuesday, October 25, 2011 5:45 PM
  • Thanks Mariano, nice to get an straight answer, knowing I didn't missunderstand the installation instructions. It is a pity MS don't think it is important to update the installation prereqs ... "You must have the Enterprise, Evaluation, Developer, or Data Center edition of SQL Server 2008 R2."

    The link you gave doesn't have Developer edition listed. Is Developer and Express the same editions perhaps?

    Cheers!

    /Owe

    Wednesday, October 26, 2011 6:42 AM
  • Hi Owe and Mariano,

    I just verified that PowerPivot setup roles are available in the Developer edition, 64 bit, so the issue must be something else. Maybe the OS???

    Both the developer edition and evaluation edition have feature parity with enterprise, so that is why they are not listed in the link provided by Mariano, or in this topic in Books Online: http://msdn.microsoft.com/en-us/library/cc645993.aspx#SSAS   The differences among dev, eval and ent are number of connections and the software expiration (in the case of eval edition).

     

     


    Heidi Steen (MSFT)
    Wednesday, October 26, 2011 11:48 PM