Monday, February 13, 2012
401 error?
http://myserver/reports
I get the following error
The request failed with HTTP status 401: Unauthorized.
Is there any error happening with respect to web service level' If so how
can I track that service'I am having the same issue. Reporting Services was successfully installed
several months ago and rran beautifully but has gone belly up on a mission
critical application. I am busily RTFMing but if anybody has any bright
ideas I'd be eternally grateful!
"sqlster" wrote:
> When I try to access the reports site using
> http://myserver/reports
> I get the following error
> The request failed with HTTP status 401: Unauthorized.
> Is there any error happening with respect to web service level' If so how
> can I track that service'
>|||dbahawk wrote:
> I am having the same issue. Reporting Services was successfully installed
> several months ago and rran beautifully but has gone belly up on a mission
> critical application. I am busily RTFMing but if anybody has any bright
> ideas I'd be eternally grateful!
> "sqlster" wrote:
>
>>When I try to access the reports site using
>>http://myserver/reports
>>I get the following error
>>The request failed with HTTP status 401: Unauthorized.
>>Is there any error happening with respect to web service level' If so how
>>can I track that service'
looks like you're trying to access IIS anonymously, or anonymous access
allowed at IIS side.
Both will cause this error.|||Thanks for your swift reply!
However, I do have anonymous access turned off for the websites _Reports_
and _ReportServer_
When I try to connect to a previously working report, I get the following
error:
Here is the error and stack trace:
[begin error message]
Source Error:
An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.
Stack Trace:
[WebException: The request failed with HTTP status 401: Unauthorized.]
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
message, WebResponse response, Stream responseStream, Boolean asyncCall) +1303
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters) +218
coiWeb.domain.domain.domain.domain.ReportingService.Render(String Report,
String Format, String HistoryID, String DeviceInfo, ParameterValue[]
Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle,
String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed,
Warning[]& Warnings, String[]& StreamIds) +143
coiWeb.print_form.Page_Load(Object sender, EventArgs e) +867
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +744
----
Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET
Version:1.1.4322.2300
[end of error message]|||I should also add that I am able to log into the site
[domaininfo]/ReportServer and run these manually, so the reporting services
installation does not seem to be the problem. It's getting access to
[domaininfo]\Reports that is the hangup here.
"dbahawk" wrote:
> Thanks for your swift reply!
> However, I do have anonymous access turned off for the websites _Reports_
> and _ReportServer_
>
> When I try to connect to a previously working report, I get the following
> error:
> Here is the error and stack trace:
> [begin error message]
> Source Error:
> An unhandled exception was generated during the execution of the current web
> request. Information regarding the origin and location of the exception can
> be identified using the exception stack trace below.
> Stack Trace:
>
> [WebException: The request failed with HTTP status 401: Unauthorized.]
> System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> message, WebResponse response, Stream responseStream, Boolean asyncCall) +1303
> System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters) +218
> coiWeb.domain.domain.domain.domain.ReportingService.Render(String Report,
> String Format, String HistoryID, String DeviceInfo, ParameterValue[]
> Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle,
> String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed,
> Warning[]& Warnings, String[]& StreamIds) +143
> coiWeb.print_form.Page_Load(Object sender, EventArgs e) +867
> System.Web.UI.Control.OnLoad(EventArgs e) +67
> System.Web.UI.Control.LoadRecursive() +35
> System.Web.UI.Page.ProcessRequestMain() +744
>
> ----
> Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET
> Version:1.1.4322.2300
> [end of error message]
>|||I found the references to the DisableLoopbackCheck registry entry and applied
it to our development server. Worked great so I applied it to the production
box where it also worked like a charm.
All is good again :)
"dbahawk" wrote:
> I should also add that I am able to log into the site
> [domaininfo]/ReportServer and run these manually, so the reporting services
> installation does not seem to be the problem. It's getting access to
> [domaininfo]\Reports that is the hangup here.
>
> "dbahawk" wrote:
> > Thanks for your swift reply!
> >
> > However, I do have anonymous access turned off for the websites _Reports_
> > and _ReportServer_
> >
> >
> > When I try to connect to a previously working report, I get the following
> > error:
> >
> > Here is the error and stack trace:
> >
> > [begin error message]
> >
> > Source Error:
> >
> > An unhandled exception was generated during the execution of the current web
> > request. Information regarding the origin and location of the exception can
> > be identified using the exception stack trace below.
> >
> > Stack Trace:
> >
> >
> > [WebException: The request failed with HTTP status 401: Unauthorized.]
> >
> > System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> > message, WebResponse response, Stream responseStream, Boolean asyncCall) +1303
> > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > methodName, Object[] parameters) +218
> > coiWeb.domain.domain.domain.domain.ReportingService.Render(String Report,
> > String Format, String HistoryID, String DeviceInfo, ParameterValue[]
> > Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle,
> > String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed,
> > Warning[]& Warnings, String[]& StreamIds) +143
> > coiWeb.print_form.Page_Load(Object sender, EventArgs e) +867
> > System.Web.UI.Control.OnLoad(EventArgs e) +67
> > System.Web.UI.Control.LoadRecursive() +35
> > System.Web.UI.Page.ProcessRequestMain() +744
> >
> >
> > ----
> > Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET
> > Version:1.1.4322.2300
> >
> > [end of error message]
> >
> >
400: Bad Request
The Reportserver itself and reports works fine (http://servername/reportserver).
Reports render OK and i am still able to connect to reportserver by management studio.
The environment is a W2K3 Standard with SQL 2005 (Build 2153) - and the server is a domain controller.
Reporting Service Configuration does not mention any issues - I have reapplied default settings - no change.
There are no errors in the eventlog.
I need some help - please
HANNESI have already checked the following posts
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=284929&SiteID=1
(I did not understend the "RSWebApplication.config" file - as soon as i write in the a reportserver url the website returns an execption - so this config must be empty I guess)
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=479636&SiteID=1|||This post gave me the finale hint (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=165851&SiteID=1) - but I do not habe a specific IP address bound to the website - but I had specific hostheaders and it seems the reportmanager needs at least one binding with no hosthader in my environment - therefor I added a fifth binding with no hosthander, no specific IP and default Port
Hannes