Using PerformancePoint Services - Business Intelligence in Microsoft SharePoint 2013 - page 229

FIGURE 8-9 The PerformancePoint Service Application Settings page.

Caution You should limit the access for the Unattended Service Account to only needed
data sources in SQL Server. Also, set this account to read-only access on any data sources so
that it has minimum permissions and minimizes vulnerability. You can check the SSS to see
that a Target Application for PerformancePoint has been created for you.

Troubleshooting the SQL Server data-source configuration
The following are some things you can do to troubleshoot SQL Server data-source configuration:

You might need to register the service account to the existing application pool dedicated to
PerformancePoint Services.

■

You will do this when using an account for the identity of the PerformancePoint service that
is different from the identity for the content database(s). This concept also applies to Excel
Services and PowerPivot. To do this, use Windows PowerShell (as Administrator) and run the
following cmdlets:

PS C:\> $w = Get-SPWebApplication(" <your web application> ")

PS C:\> $w.GrantAccessToProcessIdentity(" <insert service account> ")

Note This action grants db_owner access to the SharePoint content databases.