"The request failed with HTTP status 401: Unauthorized" SQl server reports

I am using SQL Server Reporting. All reports are deployed on REPORTING SERVER.

I want to implement security roles as same as in Active directory. Currently reports are being accessed using Anonymous user setting in IIS.

I have added users in SQL Server security as well as data base level. But when user accesses report following error occurs:

The request failed with HTTP status 401: Unauthorized

Please reply with solution as soon as possible. I will be very thankful to you

So, this is an IIS error which means that the request doesn't event make it to the Report Server. You can try creating a simple website with a single page in it and configure this website for Windows Integrated security. You will probably get the same error. You need to find why IIS is rejecting the web request.

#### Security on Report Manager ####

Hi:
I have security settings for everyone as browser on my home directory of the
report manager. No matter what settings I have for the browser role, (view
reports lets him view report properties as well). But i dont want my users to
go in and chnage the data source properties or parameters. How can i not show
the properties tab for the reports, but still have the susbcription available.
ThanksIf the account your testing with sees other report properties than jsut the
General properties (which would not let them get at the
data source) then it is not coming in as "Everyone". May be the account
you are testing with is a member of a higher privelege group.
"Everyone" should have the ability to access subscriptions so long as report
is being executed using stored credentials.
--
-- "This posting is provided 'AS IS' with no warranties, and confers no
rights."
jhmiller@.online.microsoft.com
"NI" <NI@.discussions.microsoft.com> wrote in message
news:5D49B753-7185-49B1-92C5-249A0A6E0788@.microsoft.com...
> Hi:
> I have security settings for everyone as browser on my home directory of
> the
> report manager. No matter what settings I have for the browser role,
> (view
> reports lets him view report properties as well). But i dont want my users
> to
> go in and chnage the data source properties or parameters. How can i not
> show
> the properties tab for the reports, but still have the susbcription
> available.
> Thanks|||Thats exactly what I want, browser be able to see just general properties and
subscription, and not get to parameters and data sources. And you may be
right when you say, the acocunt I am testing with is not coming in as
Everyone. Before I had "everyone" set up on the home directory, I used to
have a bunch of accounts (individual user in the format domain\user) set up.
Now I removed all those individual settings and have just everyone. But when
I look at the ReportServer DB and Users table, it has everyone with userType
1 and Auth Type 1. And it has those individual user accounts I used to have
with userType 1and Auth Type 1, and it has some other indivual accounts
(whihc I never set up, but they r probably hitting the reports coz everyone
can see them), with userTpe 0 and authType 1. Also one wierd thing, it has
"domain\" with UserType 1 and AuthType 1.
Anything wrong happening here.
Thanks a bunch
"John H. Miller" wrote:
> If the account your testing with sees other report properties than jsut the
> General properties (which would not let them get at the
> data source) then it is not coming in as "Everyone". May be the account
> you are testing with is a member of a higher privelege group.
> "Everyone" should have the ability to access subscriptions so long as report
> is being executed using stored credentials.
> --
> -- "This posting is provided 'AS IS' with no warranties, and confers no
> rights."
> jhmiller@.online.microsoft.com
> "NI" <NI@.discussions.microsoft.com> wrote in message
> news:5D49B753-7185-49B1-92C5-249A0A6E0788@.microsoft.com...
> > Hi:
> >
> > I have security settings for everyone as browser on my home directory of
> > the
> > report manager. No matter what settings I have for the browser role,
> > (view
> > reports lets him view report properties as well). But i dont want my users
> > to
> > go in and chnage the data source properties or parameters. How can i not
> > show
> > the properties tab for the reports, but still have the susbcription
> > available.
> >
> > Thanks
>
>