DB security for SSRS

Last Post 21 Jul 2011 09:10 AM by PaulMcKibben. 4 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
PaulMcKibben
New Member
New Member

--
20 Jul 2011 12:20 PM

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.

 

rm
New Member
New Member

--
20 Jul 2011 01:13 PM
User doesn't need permission in RS dbs, only RS service account does.
PaulMcKibben
New Member
New Member

--
20 Jul 2011 01:53 PM
RM,

Thank you. I understand that the users do not need permission to the ReportServer or ReportServerTempDB.

My question is about the source database that the report is built over.

I build a report over DatabaseA, what permissions other then db_datareader do the end-user clients need to execute the report and retrieve data?

Thank you again.
rm
New Member
New Member

--
21 Jul 2011 05:44 AM
Good enough with db_datareader to run the report unless it calls some sps/functions in the report that needs exec permission on related sps/functions.
PaulMcKibben
New Member
New Member

--
21 Jul 2011 09:10 AM
RM,

Thank you again.



Acceptable Use Policy
---