A user of mine cannot bring up a report in Sharepoint. They are getting the following error:
The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference).
I did some research via Google and it points towards reconnecting the report to the data source. However, I cannot find this report in report server.
Where would I go to find a repository of all reports created? According to some messages that pop up when I try to launch SSRS or Business Studio (in my futile search for this report), it suggest that Report server was integrated to Sharepoint.
I don't even get the option to enter in parameters, which means the report doesn't even launch before throwing up the errors. As soon as I click on the link from the user's workstation, I get the error:
· An error has occurred during report processing. (rsProcessingAborted) o Cannot create a connection to data source 'DataSourceName'. (rsErrorOpeningConnection) For more information about this error navigate to the report server on the local server machine, or enable remote errors.
Report Server logs from the server show:
System.Data.SqlClient.SqlException: Setuser failed because of one of the following reasons: the database principal 'Domain\Philip' does not exist, its corresponding server principal does not have server access, this type of database principal cannot be impersonated, or you do not have permission.
It works from my workstation and my fellow admin's workstation but not others so I figure it must be a permissions issue but where can I check and change these permissions to allow the report to run?