The permissions granted to user ' are insufficient for performing this operation. (rsAccessDenied)"}

Question

created a report model using SSRS (2005) and then published local server. But when i tried to run report for the model i published using report builder i do get the following error.

Report execution error:The permissions granted to user are insufficient for performing this operation. (rsAccessDenied)

Answer 1

under Site setting in Reports manager >Configure system-level role definitions > check ExecuteReport Defination option then Create a System UserGroup, Give the access to that group at Connect to your reporting Services Data base in server properties and add a group and permite the access as System User... It should work if not Please contact me at kanajam'at'yahoo.com

Thanks Kamal 732 543 6320

Answer 2

what does this mean? "Give the access to that group at Connect to your reporting Services Data base in server properties and add a group and permite the access as System User"

Answer 3

I have SQL2008/Windows 2008 Enterprise - - Here is what I had to do to correct rs.accessdenied, 404, 401, 503 errors:
Added NT Users to SQL Report Server Users and IIS_USR Group I changed SQL Reporting Service to Local account (it was Domain with Local Admin) I deleted encryption key in Reporting Services Configuration (last tab on the list) and THEN it worked...

[email protected]

Answer 4

What worked for me was:

• Go to Site Setting
• Click on "Configure site-wide security"
• Click "New Role Assignment" button in top bar
• Give the new role the following name "Everyone"
• Of the available roles, grant it "System User" only
• Click "Apply"

That should do it,

Good luck!

Answer 5

I know it's for a long time ago but you (or any other new comers) can resolve this issue by

1. Add the [Domain\User] to Administrator, IISUser, SQLReportingUser groups
2. Delete Encryption Key in SSRS configuration tools
3. ReRun the Database Change in SSRS configuration tools
4. Open WebServiceUrl from SSRS configuration tools (http://localhost/reportserver)
5. creating Reports Folder manually
6. go to Properties of created folder and add these roles to security (builtin\users , builtin\Administrator, domain\user)
7. Deploy your reports and your problem resolved

Answer 6

I got stuck with step 4: it still shows the rsAccessDenied message. The group names were slightly different: IIS_IUSR, Administratoren, SQLServerReportServerUser$NBWWI$MSRS10_50.MSSQLSERVER (DE installation) Any idea would be appreciated.