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
  • April 2009
    M T W T F S S
    « Mar   May »
     12345
    6789101112
    13141516171819
    20212223242526
    27282930  
  • .

    .Net Agile Antivirus Book C# Programming EntityFramework GTD Hyper-V LinQ MVVM Office Resharper SCRUM Security Sharepoint Silverlight SQLServer TFS ToDoList Unit Test VirtualBox Virtual PC Visual Studio VMware Windows7 WPF XeDotNet XML XPath

  • Follow

    Get every new post delivered to your Inbox.