Techbubbles

Configuring Power Pivot for SharePoint 2010

This post explains about how to install and configure the Power Pivot for SharePoint 2010. You can read installation instructions for SharePoint 2010 here. You need to install SharePoint 2010 with un-configure state. You will be having the PowerPivot for SharePoint package in SQL Server 2008 R2 media. We are using new server installation option in SQL Server 2008 R2 setup.

SP2010

Install SharePoint Server 2010(Do not configure)

1. Open the SharePoint 2010 enterprise setup containing folder and run the Prerequisite installer as an administrator.

2. Run setup file to install the SharePoint Server software.

image

click the server farm button from above window. Standalone installation is not supported powepivot features.

3. After completion of the installation you will get the following window.

Install page prompting for more configuration

Do not configure the server at this moment and uncheck the box as shown above.

Install PowerPivot and configure SQL server

You run the SQL Server 2008 R2 setup, it installs and configures the PowerPivot for SharePoint. The Same database instance is used as SharePoint database server.

1. open the SQL server 2008 R2 setup and run the setup file as an administrator.

image

2. Click the new installation option from above window

image

3. In Setup Support Rules, just click OK. Select the installation type from the following window

image

4. In Setup Role, Select SQL Server PowerPivot for SharePoint.

image

5. Select the SQL Server PowerPivot for SharePoint and then select the New server from drop down and click next to see the read-only features window

image

 

image

6. Click next to see the instance configuration window

image

a read only instance of powerpivot is displayed and this name can not be modified. click next

7. In New SharePoint Farm configuration, enter a domain account for the server farm account.

image 

specify the pass phrase and port number for SharePoint Central Administration site. click next

8. In server configuration, enter the account information for datase and analysis services. click next

 image

9. In Database configuration, enter current user to grant the administrator permissions on the Database Engine.

image 

10. In Analysis Service configuration, add the current user

image

click on each of the remaining pages till you get the ready to install page.

To verify the installation go to the SharePoint central administration

image

Click the System Settings and click the manage services on server verify that PowerPivot Integration Feature is active.

In Central administration screen, system settings then click on manage services on server verify SQL Server Analysis services and SQL Server PowerPivot System service are started.

More articles about Power Pivot can be found here


Share this post :


Related Posts:

%d bloggers like this: