A PowerPivot for SharePoint deployment requires that your farm include the following services: Excel Calculation Services, Secure Store Service, and Claims to Windows token service.
The Claims to Windows Token Service is required for Excel Services and PowerPivot for SharePoint. It is used to establish connections to external data sources using the Windows identity of the current SharePoint user. This service must run on every SharePoint server that has Excel Services or PowerPivot for SharePoint enabled. If the service is not already started, you must start it now to enable Excel Services to forward authenticated requests to the PowerPivot System Service.
- In Central Administration, in System Settings, click Manage services on server.
- Start the Claims to Windows Token Service.
- Start Excel Calculation Services.
- Start Secure Store Service.
- Verify that both SQL Server Analysis Services and SQL Server PowerPivot System Service are started.
The next step is to create a PowerPivot service application.
- In Central Administration, in Application Management, click Manage service applications.
- In the Service Applications ribbon, click New.
- Select SQL Server PowerPivot Service Application. If it does not appear in the list, PowerPivot for SharePoint is not installed or the solution is not deployed.
- In the Create New PowerPivot Service Application page, enter a name for the application. The default is PowerPivotServiceApplication
. If you are creating multiple PowerPivot service applications, a descriptive name will help other administrators understand how the application is used.
- In Application Pool, create a new application pool and select a security account for it. A domain user account is required.
- In Database Server, choose a database server on which to create the service application database. The default value is the SQL Server Database Engine instance that hosts the farm configuration databases.
- In Database Name, the default value is PowerPivotServiceApplication1_
. The default database name corresponds to the default name of the service application. If you entered a unique service application name, follow a similar naming convention for your database name so that you can manage them together.
- In Database Authentication, the default is Windows Authentication. If you choose SQL Authentication, refer to the SharePoint administrator guide for best practices on how to use this authentication type in a SharePoint deployment.
- Select the checkbox for Add the proxy for this PowerPivot service application to the default proxy group. This adds the service application connection to the default service connection group. You must have at least one PowerPivot service application in the default connection group.
If a PowerPivot service application is already listed in the default connection group, do not add a second service application to that group. Adding two service applications of the same type of the default connection group is not a supported configuration. For more information about how to use additional service applications in a connection group, see How to: Connect a PowerPivot Service Application to a SharePoint Web Application.
- Click OK. The service will appear alongside other managed services in the farm's service application list.