I have a problem when creating a report in Performance Point's Dashboard Designer. I am able to create a data source and the connection is successful but when I create a report using this data source I get the following error:
"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."
I didn't have this problem while the database I was using was on the local server, and now it's on another server. I tried googling the problem but the solutions that are there for this problem are not working. I make all the neccessary settings for the application pool in IIS - I set as an identity a user that has full permission to the database, which is usually the solution to the problem that gives this error, but I still get the error. Does anyone know what might be the problem?