Install SQL Server PowerPivot for SharePoint

Run SQL Server 2008 R2 Setup to add PowerPivot for SharePoint to a SharePoint farm. If the farm consists of multiple SharePoint servers, you must run SQL Server 2008 R2 Setup on an application server that is already joined to the farm.

Note
This procedure assumes that the computer does not have a prior SQL Server installation. If you previously installed SQL Server components, pages in the Installation Wizard will appear in a slightly different order.

1. On computer that already has an installation of SharePoint 2010, insert the installation media or open a folder that contains the setup files for SQL Server 2008 R2.
2. Run SQL Server Setup with administrator permissions. Right-click Setup.exe and select Run as Administrator.
3. Click Installation on the navigation pane to the left.
4. Click New installation or add features to an existing installation.
5. In Setup Support Rules, click OK if no problems were detected. Otherwise, follow the instructions on the page to correct the problems and then restart setup.
6. In Setup Support Files, click Install.
7. Click Next.
   

   Note

   If Windows Firewall is enabled, you will be warned to open ports to enable remote access. This warning is generally not applicable to PowerPivot installations. Connections to PowerPivot services and data files are made using the SharePoint ports that are already open for SharePoint service-to-service communication. You only need to open ports if you are installing other SQL Server features that require data access from a remote computer. Examples include using traditional Analysis Services data sources as an external data source for a PowerPivot workbook, using client applications such as SQL Server Management Studio to browse a PowerPivot workbook that is loaded on a remote SharePoint server, or setting up a Database Engine as a database server for a multi-server SharePoint farm. For more information about how to open ports used by these servers, see Configuring the Windows Firewall to Allow SQL Server Access.

8. In Installation Type, select New installation or add features. This page only appears if you already have an existing instance installed. Do not select Add features to an existing instance of SQL Server 2008 R2. PowerPivot for SharePoint must be installed as a new instance. Click Next.
9. In Product Key, specify the Evaluation edition or enter a product key for a licensed copy of the Enterprise, Developer, or Data Center edition. Click Next.
10. Accept the Microsoft Software License Terms of agreement, and then click Next.
11. In Setup Role, select SQL Server PowerPivot for SharePoint.
12. Also on the Setup Role page, in Add PowerPivot for SharePoint to:, select Existing farm. Click Next.
13. In Feature Selection, view a read-only list of the features that will be installed. This list is displayed for informational purposes. You cannot add or remove items that are preselected for this role. Click Next.
14. In Installation Rules, click Next.
15. In Instance Configuration, a read-only instance name of 'PowerPivot' is displayed for informational purposes. This instance name is required and cannot be modified. However, you can enter a unique Instance ID to specify a descriptive directory name and registry keys. Click Next.
16. In Disk Space Requirements, verify you have sufficient disk capacity to install the feature, and then click Next.
17. In Server Configuration, specify a domain user account for SQL Server Analysis Services. Do not use a built-in system account, such as Local System or Network Service. Specifying a domain user account is required for installing Analysis Services in a SharePoint farm. For more information about account recommendations, see Plan a PowerPivot Deployment in a SharePoint Farm. Click Next.
18. In Analysis Services Configuration, click Add Current User.
19. In the same page, add the Windows user account of any person who requires administrative permissions on the Analysis Services service instance. Any user who wants to connect to an Analysis Services service instance in SQL Server Management Studio to troubleshoot database connection problems or get version information must have system administrator permissions on the server. Add the user account of any person who might need to troubleshoot or administer the server now.
20. Click Next.
21. Click Next on each of the remaining pages until you get to the Ready to Install page.
22. Click Install.