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

reporting-services reporting reportingservices-2005
jbcedge picture jbcedge · Sep 25, 2008 · Viewed 375.4k times · Source

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

Emad Mokhtar picture Emad Mokhtar · Jun 20, 2011

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

Related questions

Passing parameter via url to sql server reporting service

I'm trying to pass a parameter via the url to SSRS and it appears not to work! I'm trying to pass a userId (string) via the url which will be passed to the database and used by the query. base …

Read More
SSRS: Showing the correct execution time on a two page report?

I'm just wondering how I can show the correct execution time on a report? Until recently I had been using the following in the footer of my reports as a label expression: ="Execution Time: " + IIf(System.DateTime.Now.Subtract(Globals!…

Read More
SSRS expression to format two decimal places does not show zeros

I am using the following expression to format my value to show only two decimal points. Which Works fine if the value is not 0. However when the value is 0 it does not show 0. eg. Expression used =Format(Fields!CUL1.Value, "##.##") …

Read More