Report Access
-
I have several reports deployed and a few of my users cannot connect using the datasouce. The majority of my users connect without issue. All users are members of a role that grants permission to all necessary objects.
The error returned is:
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 'ORTHOVITA\GChambers'
Our os is windows server 2003
DB is sql 2000 using windows authentication
Development environment is VS.net 2003
Thanks in advance for any help :>
-
Do these users exist in the database and do they have permissions on the database?
-
yeah - all users exist and the have public permissions to the database and select permission on views and tables and execute permissions on procedures and functions.
However, only 3 of the 20 plus users get the error message. This also occurs on multiple machines when logged in with one of the failing users so it doesn't appear to be on the client side.
Everything me and my team have tried today makes it seem like a Active Directory issue not a database issue.
Brian
-
Have you tried logging in directly to the database through Query Analyzer? I'd be curious to see if that fails as well.
-
will try that now.
Here is something interesting...
One of our team memebers created a new Active Directory user by copying one of the failing users. The new user now has full access to all reports but the user is not in the dbrole that grant permissions to the objects. Now I'm really stumped!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply