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.
