Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 The report server cannot process the report.

Author  Topic 

Pruffty
Starting Member

14 Posts

Posted - 2012-06-26 : 13:11:30
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.

How can I go about resolving this?

Thanks

Pruffty
Starting Member

14 Posts

Posted - 2012-06-28 : 10:33:40
any answer to this? Anyone know?
Go to Top of Page

Pruffty
Starting Member

14 Posts

Posted - 2012-07-10 : 16:45:39
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?
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-07-10 : 17:00:28
see

http://technet.microsoft.com/en-us/library/bb326285(v=sql.100)

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -