How to solve "The request failed with HTTP status 401: Unauthorized" for accessing SSRS report[Answered] RSS

1 reply

Last post Oct 13, 2013 11:41 AM by MSDN_ice

‹ Previous Thread|Next Thread ›

Shortcuts

umanuwin

Member

2 Points

12 Posts

How to solve "The request failed with HTTP status 401: Unauthorized" for accessing SSRS report

Oct 10, 2013 04:08 AM|umanuwin|LINK

Dear Experts

I made an ASP.net web page with using report viewer for accessing SSRS report. The ASP.net page with report viewer are stored at Web server (192.168.60.1xx) and SSRS report is located at SSRS report server (192.168.60.2xx). However, for the web server (i.e. ASP.net page with report viewer) has joined "domain - dm001" and the SSRS server not.

I was trying to browse the ASP.net web page from different devices but their network as same as web server. They are also shown the error "The request failed with HTTP status 401: Unauthorized". So how could I solve this problem? Does any experts can help on this issue? Thanks so much!

More information about the error page:

Server Error in '/localhost_5283' Application.

The request failed with HTTP status 401: Unauthorized.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Net.WebException: The request failed with HTTP status 401: Unauthorized.

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.]
   Microsoft.Reporting.WebForms.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection.GetSecureMethods() +192
   Microsoft.Reporting.WebForms.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection.IsSecureMethod(String methodname) +51
   Microsoft.Reporting.WebForms.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection.SetConnectionSSLForMethod(String methodname) +12
   Microsoft.Reporting.WebForms.Internal.Soap.ReportingServices2005.Execution.ProxyMethodInvocation.Execute(RSExecutionConnection connection, ProxyMethod`1 initialMethod, ProxyMethod`1 retryMethod) +465
   Microsoft.Reporting.WebForms.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection.LoadReport(String Report, String HistoryID) +180
   Microsoft.Reporting.WebForms.SoapReportExecutionService.LoadReport(String report, String historyId) +24
   Microsoft.Reporting.WebForms.ServerReport.EnsureExecutionSession() +70
   Microsoft.Reporting.WebForms.ServerReport.Render(String format, String deviceInfo, PageCountMode pageCountMode, String& mimeType, String& encoding, String& fileNameExtension, String[]& streams, Warning[]& warnings) +50
   index.btnSSRS_Export_PDF_Click(Object sender, EventArgs e) +177
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +9552874
   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +103
   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +35
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1724

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.18055

- Reply
MSDN_ice
Participant

1061 Points

332 Posts

Re: How to solve "The request failed with HTTP status 401: Unauthorized" for accessing SSRS repor...

Oct 13, 2013 11:41 AM|MSDN_ice|LINK

Hi umanuwin,

This is a known issue, Please follow below links which contain solutions.

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/14df5349-db94-41df-a2b7-cc1fcf9b7387/the-request-failed-with-http-status-401-unauthorized-reporting-service?forum=sqlreportingservices

http://forums.asp.net/t/984954.aspx

Hope this helps. thanks.

SSRS asp.net