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.
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.
[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
In generally, this error occurs when the user is not authorized to the Report Server. Also, this error will occur, if Reporting Services is configured to use Kerberos, we didn’t register Services Principal Name(SPN) for the account the Reporting Services is running render.
In order to solve the issue, you can refer to the following steps:
1. Make sure the user is able to connect to the Report Server.
2. If using Kerberos authentication, please make sure SPN is configured correctly.
You can refer to these article about Configure Windows Authentication on the Report Server and Register a Service Principal Name (SPN) for a Report Server.
There is a similar thread, you can refer to it.
We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time.
Thanks for helping make community forums a great place.
- Marked as answer by Alisa TangMicrosoft contingent staff, Moderator Thursday, October 17, 2013 12:43 PM