?
Solved

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

Posted on 2004-08-05
4
Medium Priority
?
19,380 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Suggested Courses

752 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