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

Question

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

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

Answer 1

It's because of lack of privilege for the user you are running the report builder, just give that user or a group a privilege to run report builder. Please visit this article

Or for shortcut:

1. Start Internet Explorer using "Run as Administrator"
2. Open http://localhost/reports
3. Go to properties tab (SSRS 2008)
4. Security->New Role Assignment
5. Add DOMAIN/USERNAME or DOMAIN/USERGROUP
6. Check Report builder

Answer 2

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