Reporting Services 2008 – Troubleshooting Insufficient Permissions Granted

Description of issue:  When deploying a report, the deploy fails with the error: “The permissions granted to user <mydomain\myuser> are insufficient for performing this operation.”

Check the following

Check your report project’s properties window

  • TargetDataSourceFolder, TargetReportFolder and TargetServerURL must be filled.

You must have the proper permissions in the Report Manager

  • Run Internet Explorer (As an Administrator)
  • Add Report Manager base url (http://localhost/) to Trusted Sites Security, if necessary
  • Select the Properties tab
  • Select the New Role Assignment link
  • Enter your username
  • Select CONTENT MANAGER, then click OK
  • Click on Site Settings (in the upper right-hand corner)
  • Select Security (in the left border)
  • Select the New Role Assignment link
  • Enter your username
  • Select SYSTEM ADMINISTRATOR, then click OK

Advertisements

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s