Major SSRS gotcha – Report Builder – The permissions granted to user ‘domain\user’ are insufficient for performing this operation

Environment: SQL Server 2012 SSRS

Resulting in dialogues like this or similar message

image_thumb_2

And even though you have assigned all the right permissions on the site and additionally just to be sure on the folder but still…

Then try considering “User Account Access” issues. Try “Run as Administrator”. As it has worked for many and it might do for you too. Either on report builder or IE where you launch Report Builder from.

image_thumb_3

 

See this connect entry for details. Go through comments as well.

 

 

 

 

 

 

 

 

Advertisements
About

IT professional with wider interest in technology

Tagged with: , , , ,
Posted in sql, tsql, windows
2 comments on “Major SSRS gotcha – Report Builder – The permissions granted to user ‘domain\user’ are insufficient for performing this operation
  1. Yogesh says:

    I have created NEW SSRS report having code of 44000 lines. It is having 25 Line charts.
    When I try to Build or Run the report it fails.
    When I remove few charts and Build or Run it works.

    How to resolve this?

    Like

    • szzaidi says:

      Do you need to show all the charts at once?

      Try loading the report empty without default parameters also try making them conditionally visible and break your report in sections with page breaks this will make it lighter to load.

      Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

%d bloggers like this: