locked
powerpivot and sql server 2008 questions RRS feed

  • Question

  • 2 Questions

    1) If I only have sql server 2008, can i install powerpivot and sharepoint 2010 without having to install sql server 2008 R2?

    2) when sql server 2008 r2 is released for sale, will their be a developers edition, just like   sql server 2008 ?


    Steven David Taub
    Saturday, February 5, 2011 7:37 PM

Answers

  • Hi Steven,

    1. To install PowerPivot for Excel you need Excel 2010 only. To install PowerPivot for SharePoint you need SharePoint 2010 and SQL Server 2008 R2

    2. SQL Server 2008 R2 is already released for sale. It does have a Developer Edition just like previous versions (e.g. 2008).

     


    Boyan Penev --- http://www.bp-msbi.com
    • Marked as answer by Raymond-Lee Wednesday, February 23, 2011 3:10 AM
    Monday, February 7, 2011 7:28 AM
  • SQL Server 2008 R2 is the version of SQL Server after 2008, so you will need to buy it to upgrade. However, the Developer Edition usually comes very cheap in case you want to use it on a workstation. The price tag gets high when you start looking at the server editions (like the one you need for SharePoint).

    For a detailed list of the hardware and software requirements for installing PowerPivot for SharePoint have a look at:

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


    Boyan Penev --- http://www.bp-msbi.com

    Give us some candy - please upvote helpful posts and mark your answers!

    • Marked as answer by stfromli Tuesday, July 26, 2011 8:42 PM
    Wednesday, July 20, 2011 11:40 PM

All replies

  • Hi Steven,

    1. To install PowerPivot for Excel you need Excel 2010 only. To install PowerPivot for SharePoint you need SharePoint 2010 and SQL Server 2008 R2

    2. SQL Server 2008 R2 is already released for sale. It does have a Developer Edition just like previous versions (e.g. 2008).

     


    Boyan Penev --- http://www.bp-msbi.com
    • Marked as answer by Raymond-Lee Wednesday, February 23, 2011 3:10 AM
    Monday, February 7, 2011 7:28 AM
  • Hy Boyan.  Does this mean I have to buy the R2 version? Or can I download it and replace SQL 2008 as an upgrade for no charge?
    Steven David Taub
    • Proposed as answer by Boyan Penev Wednesday, July 20, 2011 11:34 PM
    • Unproposed as answer by Boyan Penev Wednesday, July 20, 2011 11:34 PM
    Wednesday, July 20, 2011 5:41 PM
  • SQL Server 2008 R2 is the version of SQL Server after 2008, so you will need to buy it to upgrade. However, the Developer Edition usually comes very cheap in case you want to use it on a workstation. The price tag gets high when you start looking at the server editions (like the one you need for SharePoint).

    For a detailed list of the hardware and software requirements for installing PowerPivot for SharePoint have a look at:

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


    Boyan Penev --- http://www.bp-msbi.com

    Give us some candy - please upvote helpful posts and mark your answers!

    • Marked as answer by stfromli Tuesday, July 26, 2011 8:42 PM
    Wednesday, July 20, 2011 11:40 PM