Where to install SQL Server PowerPivot for SharePoint?

Category: sql server powerpivotsp

Question

PCSQL66 on Tue, 10 Mar 2015 22:45:47


The environment is SharePoint 2013 Enterprise Edition and SQL Server 2012 SP2 Enterprise Edition.  

SQL Server 2012 SP2 Enterprise Edition is installed as default instance on a dedicated box.   All the features are selected in the Feature Selection windows during installation (see image).

Now, I need to install SQL Server PowerPivot for SharePoint.   Should it be installed on the same dedicated box?  If I understand correctly, I need to select the SQL Server PowerPivot for SharepPoint option and uncheck the checkbox Add SQL Server Database Relational Engine Services to this installation.   Does this option also install SSAS?  Since there is already an existing SSAS, will that cause problem?

Replies

bhanu_nz on Tue, 10 Mar 2015 22:56:58


Hi,

Please read this link

https://technet.microsoft.com/en-us/library/ee210650(v=sql.105).aspx

Cheers

Bhanu

Charlie Liao on Thu, 12 Mar 2015 02:51:33


Hi PcSQL66,

To install SQL Server PowerPivot for SharePoint, you need to select SQL Server PowerPivot for SharePoint on the Setup Role page. Please refer to the screenshot below.

And if you have a SSAS instance installed in your server, install SQL Server PowerPivot for SharePoint will install another SSAS instance.

For the detail information, please refer to the link below.
https://msdn.microsoft.com/en-us/library/jj219067(v=sql.110).aspx

Regards,