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...