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,303 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
I have a large data set and a SSIS package. How can I load this file in multi threading?
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.

776 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