Tuesday, October 25, 2011 11:06 AM
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.
Tuesday, October 25, 2011 5:45 PM
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:
I hope that helps.
Mariano Teixeira Neto Analysis Services SQL Server BI Microsoft Corp.
- Marked As Answer by owe Wednesday, October 26, 2011 6:38 AM
Wednesday, October 26, 2011 6:42 AM
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?
Wednesday, October 26, 2011 11:48 PM
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)