Friday, October 9, 2009

Unable to connect to SQL Server 2005 Analysis Services from Dashboard Designer

I got the folowing error Msg in Dashboard Designer after i did the PPS Instalalation.
"
The PerformancePoint Server could not connect to the specified data source. Verify that either the current user or application pool user has Read permissions to the data source, depending on your security configuration. Also verify that all required connection information is provided and correct."
Please refer this link for more detail. It solve my issue.
http://74.125.153.132/search?q=cache:thQqD6WhI7AJ:social.technet.microsoft.com/Forums/en-US/ppsmonitoringandanalytics/thread/a1633bfb-6dad-49de-9a8e-0d130e586f10+PPS+could+not+connect+to+Sql+server+Analysis+Server+Database&cd=1&hl=en&ct=clnk&gl=in

Answer:
If everything is installed on the same server then you could setup these local accounts that you have running the Application Pools to have the proper read permissions to the SSAS database by adding them into a Role with Read Definition and Read-only access to the cube(s). If you want to pass your credentials then you need to go into the web.config files in the Web Service, Preview, and SharePoint directories and modify the Bpm.ServerConnectionPerUser value in the AppSettings to True so that the credentials of the current logged in user will be passed to the database.If you are in a distributed environment then you will have to look at configuring Kerberos, Configuring Kerberos Delegation with PerformancePoint Monitoring Server, or using the CustomData option outilined here - PPS Data Connection Security with CustomData.

No comments: