can Sql server power pivot for sharepoint install in Windows web server 2008 R2

Question

Hi All,

I have my sharepoint site which is launched already and its live now. It is running in Windows web server 2008 R2 with microsoft sql server 2008 installed.But sharepoint using the own instance of sql database created while installation, not the default Sql server instance.

Based on further analysis of my project, my requirement is i have to go with

1.active directory support.

2.Power Pivot Sql server data base.

Now my question is

1.Is this possible to have active directory support in Windows web server 2008 R2.

2.How to do detach the sharepoint connection from the current Sql instance and to attach it with Sql server 2008 R2 Power Pivot.

Please help in this.

Thanks & Regards,

varathi.

 

Answer 1

 

Hello varathi,

 

The PowerPivot for SharePoint depends on a AD available to authenticate its users. The Windows Web Server 2008 R2 does not have AD capabilities.

More information on Windows Server editions here: http://www.microsoft.com/windowsserver2008/en/us/r2-compare-roles.aspx

Regarding your second question, PowerPivot does not rely on SharePoint's database. When you install it on a server, it will install a SQL Server Analisys Services server in vertipaq mode (running as a named instance "POWERPIVOT"). It is independent of the relational engine instance. Depending on how you install it, it may happen to have the relational SQL Server instance called POWERPIVOT instead of MSSQLSERVER (the default instance name). This will happen should you chose to install the "New Farm" option during the PowerPivot for SharePoint setup.

You can have detailed information on how to install PowerPivot for SharePoint here:

PowerPivot for SharePoint – Existing Farm Installation: 

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

PowerPivot for SharePoint – Single Server Installation:

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

I hope that helps.

 

Best,

Mariano

---

Mariano Teixeira Neto Analysis Services SQL Server BI Microsoft Corp.

Answer 2

Hi Mariano,

Thanks for the reply.

Regards,

varathi.