Archive for April 25th, 2009

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

April 25, 2009

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