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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 The report server cannot process the report.
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

14 Posts

Posted - 06/26/2012 :  13:11:30  Show Profile  Reply with Quote
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?


Edited by - Pruffty on 06/26/2012 13:12:10

Starting Member

14 Posts

Posted - 06/28/2012 :  10:33:40  Show Profile  Reply with Quote
any answer to this? Anyone know?
Go to Top of Page

Starting Member

14 Posts

Posted - 07/10/2012 :  16:45:39  Show Profile  Reply with Quote
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

Very Important crosS Applying yaK Herder

52326 Posts

Posted - 07/10/2012 :  17:00:28  Show Profile  Reply with Quote

SQL Server MVP

Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000