Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Database access through SRS Datasource returning rsErrorOpeningConnection Expand / Collapse
Posted Thursday, August 3, 2006 9:48 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 16, 2006 5:55 AM
Points: 8, Visits: 1

I have report security setup and all users are members of a role that grants security to all necessary DB objects.  However, 3 out of a group of 20 or more  users are gettting the following error:

An error has occurred during report processing. (rsProcessingAborted) Get Online Help Cannot create a connection to data source 'ORTHO1'. (rsErrorOpeningConnection) Get Online Help Cannot open database requested in login 'ORTHO'. Login fails. Login failed for user 'domain\user'

The failure is not object related it is database related. Database name = 'ORTHO'

Has anyone come across this problem before?

Thanks for any help in advance...



Post #299396
Posted Monday, August 7, 2006 8:00 AM


Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,041, Visits: 1
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
Post #299955
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse