June 28, 2006 at 5:07 pm
Hi,
I've published a few reports and as I'm preparing to release them to production, I'm attempting to set appropriate permissions for access and execution of them.
I've got a test user account (active directory) that can access the report but upon running it gets the following error any guidance or information on how to setup permission?
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'XXX_YYY'. (rsErrorOpeningConnection)
For more information about this error navigate to the report server on the local server machine, or enable remote errors
June 30, 2006 at 5:35 am
What authentication are you using for the data source used by report, and has the account been granted the proper permissions in the database?
July 2, 2006 at 4:39 pm
I have that prob before
so I create 1 user with DB login to access then in datasource I choose to connect using
credentials stored securely in the report server and put your user and password
it works fine for me
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply