For a user to be a Browser in SSRS, what database role must they be to run and view the report. I assumed it was datareader, but my SSRS report is returning:
An error has occurred during report processing. (rsProcessingAborted)
Cannot impersonate user for data source 'DBA_Info'. (rsErrorImpersonatingUser)
Log on failed. Ensure the user name and password are correct. (rsLogonFailed)
For more information about this error navigate to the report server on the local server machine, or enable remote errors
With the only the datareader role assigned to the user in the database.
The database that is being read is SQL 2005 SP4.
Any help is appreciated.