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,271 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
Comment Utility
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
Comment Utility
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
Comment Utility
PAQed, with points refunded (125)

CetusMOD
Community Support Moderator
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

In this article—a derivative of my DaytaBase.org blog post (http://daytabase.org/2011/06/18/what-week-is-it/)—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

744 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

18 Experts available now in Live!

Get 1:1 Help Now