Solved

SQL Reporting Services:  The permissions granted to user "<server>"\IUSR_<username>" are insufficient for performing this operation.

Posted on 2004-08-05
4
19,293 Views
Last Modified: 2011-08-18
Hi there.  

I am coming across a particularly frustrating little error...I've scoured the internet and have yet to find an answer which works for me.

I have installed SQL Server 2000 Reporting Services and have gotten it to work.  When my webservice was set to http://localhost, all was well on my machine...and other machines would get broken links.

So I moved the webservice to a dynamic location.  And now I cannot bring up SQL Reporting Services in my .aspx page.  (Viewing them through Report Manager still displays accurately on my screen, but not through an IIS webpage)  I get this error:


The permissions granted to user "<server>"\ASPNET" are insufficient for performing this operation.
or
The permissions granted to user "<server>"\IUSR_<username>" are insufficient for performing this operation.
(the 2nd appears when I include <identity impersonate="true" /> in my web.config)

I have seen a lot of talk about adding the user to Report Manager...I added the following accounts to Home, and gave them full access:
BUILTIN\Users
BUILTIN\Guests
<machinename>\ASPNET
<machinename>\IUSR_<machinename>
<machinename>
BUILTIN\Administrators (this one was already there)


Each of these accounts has full access, and I still get the error message.

Any ideas?  I have Integrated Windows Authentication set on my virtual directories...I tried anonymous access as well, and I got the same message (with the IUSR_ account specified).

At this point, I'm fried.  Anybody have any answers?  Thanks.

Jason
0
Comment
Question by:jasonwisdom
4 Comments
 
LVL 9

Expert Comment

by:crescendo
ID: 11731667
It sounds like you need to add <machinename>\ASPNET to a role in the database(s) accessed by reporting services. Does Reporting Services have its own database? If so, start there. But you may need to give it permission to access other DBs and this could be a security risk.
0
 
LVL 1

Author Comment

by:jasonwisdom
ID: 11736209
I found a solution.  It may not ultimately work for Production, but it's a start.  Here is what I did:

1) I added a LOCAL account to the IIS/Reporting Services machine (which, in this stage of the project's development, is my personal development workstation)
2) I granted that user membership to my machine's Administrators group
3) I added that user into Reporting Services Manager.
4) It worked!!

Thank you for your lead, crescendo.  The ReportServer database stores information entered through the Reporting Services Manager.  It's very simple to walk through, compared with how complicated most major Industry-released products tend to get.  However, in this case walking through the DB was of little use.

I'm going to ask that this question be deleted.  However, this solution may be useful for others, as I have seen the same question posted (and unanswered) in other places around the internet.

Jason
0
 

Accepted Solution

by:
CetusMOD earned 0 total points
ID: 12095240
PAQed, with points refunded (125)

CetusMOD
Community Support Moderator
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how the fundamental information of how to create a table.

911 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now