SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

Pruffty
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?

Thanks

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

Pruffty
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

Pruffty
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

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

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

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

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

Go to Top of Page
  Previous Topic Topic Next Topic  
 New 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.06 seconds. Powered By: Snitz Forums 2000