Configure the unattended service account for PerformancePoint Services (SharePoint Server 2013)
Published: July 16, 2012
Summary: Learn how to configure the unattended service account for PerformancePoint Services.
Applies to: SharePoint Server 2013
The unattended service account is an Active Directory account that is used for accessing PerformancePoint Services data sources. This account is used by PerformancePoint Services on behalf of authorized users to provide access to external data sources for the purposes of creating and using dashboards and other PerformancePoint Services content. To configure the unattended service account, see Configure the unattended service account for PerformancePoint Services in this article.
The unattended service account is a universal account that provides equal data access to all authorized users. If you need more fine-grained data access, see Configure Secure Store for use with PerformancePoint Services.
PerformancePoint Services uses Secure Store Service to store the unattended service account password. Before using the Unattended Service Account, make sure that Secure Store has been configured.
Before you begin
Because SharePoint 2013 runs as websites in Internet Information Services (IIS), administrators and users depend on the accessibility features that browsers provide. SharePoint 2013 supports the accessibility features of supported browsers. For more information, see the following resources:
Configure the unattended service account for PerformancePoint Services
Use the following procedure to configure the unattended service account for PerformancePoint Services.
To configure the unattended service account for PerformancePoint Services
On the SharePoint Central Administration Web site, in the Application Management section, click Manage Service Applications, and then click the PerformancePoint Services service application.
On the Manage PerformancePoint Services page, click PerformancePoint Service Application Settings.
In the Secure Store and Unattended Service Account section, enter the user name and password for the account that you want to use as the unattended service account.
You will see the Secure Store Service name and the user name that represents the unattended service account.
Once the unattended service account has been configured, you must grant that account access to your data sources:
For SQL Server data, the account must have a SQL logon with db_datareader permissions on each database that you want to access.
For SQL Server Analysis Services data, the account must have read access to the cube or an appropriate portion of the cube, depending on your needs.
For Excel Services data, the account must have access to the Excel workbook in a SharePoint document library.
For data in a SharePoint list, the account must have read access to the list.
July 16, 2012