[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


SSRS2008 Deploy report

Posted on 2011-10-26
Medium Priority
Last Modified: 2012-05-12
Hi Experts

I am migrating SQL 2005 ssrs to SQL 2008, I have upscaled my report to vs2008 and now Im trying to deploy, however its complaining about user rights,

 The permissions granted to user 'DOMAIN\MrdThorn' are insufficient for performing this operation.

I am setup as an administator on the server so Im assuming that its do with IIS access rights to the virtual SSRS directory
Question by:MrDavidThorn
LVL 29

Accepted Solution

sammySeltzer earned 2000 total points
ID: 37030605
Please see this link below:


Also, please take a look in iis and see if permission there was set to use anonymous access.

If yes, select windows integrated security since  you are using domain name.
LVL 13

Expert Comment

ID: 37030738
also .. being an local admin doesn't mean you are an admin in SQL this is split up and per default the local admins are no longer admins in sql.

You might want to check your rights in sql.

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack.  Those functions are IIF() and Switch().  And I'll be showing you how easy it is to add an Else part to the Switch function. T…
Introduction As you'll probably know, a data region in a SQL Server Reporting Services report can be linked to only one dataset.  This makes it troublesome when you need to display data from more than one dataset in the same data region.  SQL Serve…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Integration Management Part 2
Suggested Courses
Course of the Month20 days, 8 hours left to enroll

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question