Performance Point Unattended Service Account Problem

Question

When I try to configure a datasource with SharePoint List in DashBoard Designer, I am getting this error:

"PerformancePoint Services could not connect to the specified data source. Verify that either the current user or Unattended Service Account has read permissions to the data source, depending on your security configuration. Also verify that all required connection information is provided and correct."

I am using SQL Server 2012 Enterprise and SP 2010 + SP1 in two server farm configuration.

Performance Point Unattended account is entered correctly and that account has db_owner permission on WSS_Content and PerformancePoint Service Application database and is a member of Owners group in the site.

The unique application id for Performance Point Service Application is created in Secure Store.

Any idea?

Answer 1

When I try to configure a datasource with SharePoint List in DashBoard Designer, I am getting this error:

"PerformancePoint Services could not connect to the specified data source. Verify that either the current user or Unattended Service Account has read permissions to the data source, depending on your security configuration. Also verify that all required connection information is provided and correct."

I am using SQL Server 2012 Enterprise and SP 2010 + SP1 in two server farm configuration.

Performance Point Unattended account is entered correctly and that account has db_owner permission on WSS_Content and PerformancePoint Service Application database and is a member of Owners group in the site.

The unique application id for Performance Point Service Application is created in Secure Store.

Any idea?

Update : I am able to create a datasource with SQL Server table.

Answer 2

Are you getting the error message when you try to create a Multidimensional data source?  Guess I am not sure what you are trying to do that is causing the error exactly.  If so, have you verified that the credentials you are using for the Unattended Account have read permissions to the cube you are trying to access.

---

Answer 3

along with cube read acess unattended service account shouldbe a part of secure service.

Answer 4

Hello Sumedh

Did you solve this issue?Because I am also getting the same issue with SQL 2012 and SharePoint 2010.