powerpivot and sql server 2008 questions

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

Answer 1

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

Answer 2

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

Answer 3

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!