Problem Description:
Getting the following while launching SharePoint 2010 performance point dashboard designer and connecting to datasource.
Error Message:
Access Denied. You do not have permissions to connect to the server. Please contact your system administrator.
Entities used:
-SharePoint server 2010
-Performance point
-SQL Server 2008 R2
-BI template for the site collection
-IE7 + windows 7 OS
Troubleshooting done:
-Performance point service application is started or not
-performance point service is started or not
-secure store service application is started or not
-secure store service is started or not
-performance point service application is properly associated with the respective web application
-the account that we have used for configuring the performance point service application has proper rights in SQL or not
-what kind of rights user has on the specific site collection that is being used inside the dashboard designer
Resolution:
After checking all the steps and thorough analysis, we check the logs and found some traces with respect to the authentication.
We have checked the authentication part with respect to that web application and it was using claim based authentication.
As per the Microsoft theory regarding performance point services, it does not support any other authentication except windows authentication.
So conclusion is windows authentication is mandatory to make the performance point functional.
If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.
