The request failed with HTTP status 401: Unauthorized & Reportview

Hi

I am running SQL 2005 Reporting Services on my Web Server. The SQL Database
resides on a seperate Server.

I have configured a reportserver virtual directorty off my web site. When I
access this using http://xxx.com/reportserver I can view all the reports
successfully.

When I try to use the Reportview embedded in a web page located as part of
http://xxx.com to access a report at http://xxx.com/reportserver I receive a
The request failed with HTTP status 401: Unauthorized. error message.

This worked fine in SQL Server 2000 / Reporting Service 2000 but I am now
having problems. I could have sworn this was working OK after upgrading to
Visual Studio 2005 / SQL Server 2005 but a user reported the problem a week
ago and I cant seem to find a solution.

I'm using basic authentication for my web site and my web.config contains

<authentication mode="Windows"/>
<identity impersonate="true"/>

Any help would be more than appreciated.

Jéjé
Sat Feb 04 10:39:36 CST 2006

what do you see in your IIS logs?

look at this article:
http://www.devx.com/dotnet/Article/30424/1954?pf=true

there is a section of own to play with the basic authentication.


"RKP" <RKP@discussions.microsoft.com> wrote in message
news:C9D2E6DF-0BB3-4068-B0C7-D860E3A505CE@microsoft.com...
> Hi
>
> I am running SQL 2005 Reporting Services on my Web Server. The SQL
> Database
> resides on a seperate Server.
>
> I have configured a reportserver virtual directorty off my web site. When
> I
> access this using http://xxx.com/reportserver I can view all the reports
> successfully.
>
> When I try to use the Reportview embedded in a web page located as part of
> http://xxx.com to access a report at http://xxx.com/reportserver I receive
> a
> The request failed with HTTP status 401: Unauthorized. error message.
>
> This worked fine in SQL Server 2000 / Reporting Service 2000 but I am now
> having problems. I could have sworn this was working OK after upgrading
> to
> Visual Studio 2005 / SQL Server 2005 but a user reported the problem a
> week
> ago and I cant seem to find a solution.
>
> I'm using basic authentication for my web site and my web.config contains
>
> <authentication mode="Windows"/>
> <identity impersonate="true"/>
>
> Any help would be more than appreciated.

RKP
Sat Feb 04 18:36:26 CST 2006

All

Here is a line from my IIS log file. As you can see the 401 occurs
accessing the ReportExecution2005.asmx

This doesn't make any sense. I can access ReportExecution2005.asmx using
http://xxx.com/reportserver/ReportExecution2005.asmx successfully.

Thanks

2006-02-05 00:29:31 W3SVC760517435 172.31.0.16 POST
/ReportExecution2005.asmx - 80 - 172.31.0.16
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 401 2 2148074254

"Jéjé" wrote:

> what do you see in your IIS logs?
>
> look at this article:
> http://www.devx.com/dotnet/Article/30424/1954?pf=true
>
> there is a section of own to play with the basic authentication.
>
>
> "RKP" <RKP@discussions.microsoft.com> wrote in message
> news:C9D2E6DF-0BB3-4068-B0C7-D860E3A505CE@microsoft.com...
> > Hi
> >
> > I am running SQL 2005 Reporting Services on my Web Server. The SQL
> > Database
> > resides on a seperate Server.
> >
> > I have configured a reportserver virtual directorty off my web site. When
> > I
> > access this using http://xxx.com/reportserver I can view all the reports
> > successfully.
> >
> > When I try to use the Reportview embedded in a web page located as part of
> > http://xxx.com to access a report at http://xxx.com/reportserver I receive
> > a
> > The request failed with HTTP status 401: Unauthorized. error message.
> >
> > This worked fine in SQL Server 2000 / Reporting Service 2000 but I am now
> > having problems. I could have sworn this was working OK after upgrading
> > to
> > Visual Studio 2005 / SQL Server 2005 but a user reported the problem a
> > week
> > ago and I cant seem to find a solution.
> >
> > I'm using basic authentication for my web site and my web.config contains
> >
> > <authentication mode="Windows"/>
> > <identity impersonate="true"/>
> >
> > Any help would be more than appreciated.
>
>
>