locked
PowerPivot and SQL Server 2008 R2 RRS feed

  • Question

  • Hi guys,

    I'm testing PowerPivot on Microsoft Excel 2010 and sad in many places people comments that PowerPivot needs of SQL Server 2008 R2, but in my tests i used the powerpivot without SQL Server R2 and no have any problems, I installed the SQL Server 2008 R2 and no realized any diferent behavior in my tests about PowerPivot.

    Someone,  knows if is necessary the use of SQL Server 2008 R2 to PowerPivot. If yes, what's change?

    Regards,
    gcardoso

       
    Thursday, November 26, 2009 4:51 PM

Answers

  • There are two scenarios for PowerPivot.

    The first is just for personal use. For this you only need Excel 2010 and the PowerPivot download, you do not need to install SQL 2008 R2.

    The second is for sharing and publishing workbooks via Sharepoint. If you want to deploy PowerPivot workbooks to Sharepoint then you need Sharepoint 2010 and you need SQL 2008 R2 installed in Sharepoint Integrated mode.
    http://geekswithblogs.net/darrengosbell - please mark correct answers
    • Marked as answer by Raymond-Lee Sunday, December 6, 2009 3:31 AM
    Thursday, November 26, 2009 11:42 PM

All replies

  • There are two scenarios for PowerPivot.

    The first is just for personal use. For this you only need Excel 2010 and the PowerPivot download, you do not need to install SQL 2008 R2.

    The second is for sharing and publishing workbooks via Sharepoint. If you want to deploy PowerPivot workbooks to Sharepoint then you need Sharepoint 2010 and you need SQL 2008 R2 installed in Sharepoint Integrated mode.
    http://geekswithblogs.net/darrengosbell - please mark correct answers
    • Marked as answer by Raymond-Lee Sunday, December 6, 2009 3:31 AM
    Thursday, November 26, 2009 11:42 PM

  • Thanks Darren,

    So, no is necessary install SQL Server 2008 R2 to use the Power Pivot. (in both scenarios - 1-Excel 2010  / 2- SharePoint 2010).

    I really was confused about this, because in SQL Server 2008 R2 site; http://www.microsoft.com/sqlserver/2008/en/us/R2-SSBI.aspx, The Microsoft comments about PowerPivot and gives de impression that PowerPivot is a tool of SQL Server 2008 R2.

    Regards,
    gcardoso








    Friday, November 27, 2009 1:02 PM
  • You do need it for scenario 2) but not for scenario 1)

    1) Excel 2010 - Not needed
    2) Sharepoint 2010 - YES, SQL 2008 R2 is needed


    http://geekswithblogs.net/darrengosbell - please mark correct answers
    Friday, November 27, 2009 11:04 PM
  • Thank you, now understand the diferents scenarios.

    Thanks a lot!

    Tuesday, December 8, 2009 4:03 PM