Windows7: “The permissions granted to user ‘<mydomain\myuser>’ are insufficient for performing this operation.” on report’s deploy

Windows7 … got it!
Install of Reporting Services 2008 and first configuration just completed.
Now you want to deploy the “Hello World” report you just created (and test in preview),
but you get this message back: “The permissions granted to user ‘<mydomain\myuser>’ are insufficient for performing this operation.”. 😦

Some security configs are missing somewhere.
Here is a short checklist:
first check your report project’s properties window
– properties TargetDataSourceFolder, TargetReportFolder and TargetServerURL must be filled; here is an example:
TargetDataSourceFolder: DataSource
TargetReportFolder: ReportProject1
TargetServerURL: http://localhost:81/ReportServer/

then you must set security permission in ReportManager, this way:
-run (as administrator!) Internet Explorer,
-add ReportManager base url (http://localhost:81/) to Trusted Sites Security
-go to ReportManager (http://localhost:81/Reports)
-select PROPERTIES tab, then NEW ROLE ASSIGNMENT link
-fill in your user and check CONTENT MANAGER, then OK button
-then SITE SETTINGS (top right of the page), then SECURITY left border tab
-again NEW ROLE ASSIGNMENT link
-fill in your user and check SYSTEM ADMINISTRATOR, then OK button

Similar procedure if you run ReportingServices 2008 on Windows Vista or Windows 2008.

You may find more info here: How to: Configure a Report Server for Local Administration on Windows Vista and Windows Server 2008, also when your development machine is a Windows 7/Windows 2008/Windows Vista.

source: How to: Configure a Report Server for Local Administration on Windows Vista and Windows Server 2008

Technorati tags: Windows7, Reporting Services
Advertisements

Tags:

9 Responses to “Windows7: “The permissions granted to user ‘<mydomain\myuser>’ are insufficient for performing this operation.” on report’s deploy”

  1. Alexandra Says:

    thanx.

  2. jibran Says:

    wow!!! cool trick man !!

  3. Richard P Says:

    Many, many thanks – you’ve saved me from hours of hair-tearing.

  4. dag Says:

    Running Internet Explorer as an Admin was the key part. Thanks

  5. Lam Says:

    Thank you Sir, headache is gone.

  6. Chris Says:

    Thank you very much!!! You saved me hours of frustration 🙂

  7. Tom Says:

    Thanks so much. I must have spent 8 hours looking for this fix. With your instructions it took about 2 minutes. I really appreciate it!!!

  8. Kelumdt Says:

    Thanks

  9. Bineesh Thomas Says:

    Good one.

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 )

Connecting to %s


%d bloggers like this: