PowerPivot and SQL Server 2008 R2

Question

Hi guys,

I'm testing PowerPivot on Microsoft Excel 2010 and sad in more 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 different 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

   

Answer 1

Hi,

I would post that question here: http://social.msdn.microsoft.com/Forums/en-US/sqlkjpowerpivotforexcel/threads

BR
Thomas Ivarsson

Answer 2

If you want to share and publish the PowerPivot workbook to Sharepoint server and view the workbook from Sharepoint, you will need to install the middle tier Analysis Services component from SQL Server 2008 R2. 

Should you need additional information, please visit the official web site for PowerPivot http://powerpivot.com/.

Thanks!

Lisa