Request failed with HTTP status 401: Unauthorized

Oct 15, 2012 at 1:54 PM

I configured CrissCross to run on windows S2K8 and points to my SSRS 2008 server on same domain.

Criss Cross will generate the full report list, then when I attempt to run a report I receive an error [The request failed with HTTP status 401: Unauthorized]

Configuration below...

Configuration

Version: 0.8.3.2

Linked to SSRS server: http://reportsServer/Reports

Also via web service at: http://reportsServer/ReportServer/ReportService2005.asmx

Standard Report Manager is at: http://reportsServer/Reports

CrissCross Impersonation: off

CrissCross Fixed User: sqladmin

Asp.Net Impersonation: off

ASP.Net Fixed User: domain\sqladmin

You are logged in as: domain\user

Coordinator
Oct 15, 2012 at 4:42 PM

Hi, can you check the error log and tell me what the full error message/call stack is?

You can view the error log by logging onto the IIS machine and navigating to http://your_iis_server/crisscross/Elmah.axd

Oct 15, 2012 at 7:20 PM

System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.Net.WebException: The request failed with HTTP status 401: Unauthorized. at Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.GetSecureMethods() at Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.IsSecureMethod(String methodname) at Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.SetConnectionSSLForMethod(String methodname) at Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.LoadReport(String Report, String HistoryID) at Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() at Microsoft.Reporting.WebForms.ServerReport.SetParameters(IEnumerable`1 parameters) at CrissCross.Report.RunReport() in C:\Users\ian_richardson\Documents\Visual Studio 2008\Projects\CrissCrossCodeplexVersion\CrissCross\Report.aspx.cs:line 198 at CrissCross.Report.uxRunReportButton_Click(Object sender, EventArgs e) in C:\Users\ian_richardson\Documents\Visual Studio 2008\Projects\CrissCrossCodeplexVersion\CrissCross\Report.aspx.cs:line 176 at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at ASP.report_aspx.ProcessRequest(HttpContext context) in c:\Windows\Microsoft.NET\Framework64\v4.0.30319\Temporary ASP.NET Files\crisscross\79670318\3391d433\App_Web_jd4ihn0n.1.cs:line 0 at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Coordinator
Oct 15, 2012 at 10:08 PM

It seems that when IIS is talking to the SSRS web service (as domain\sqladmin), some authentication is failing.

A similar problem is discussed here, perhaps it will help?

http://stackoverflow.com/questions/2480185/sql-server-reporting-services-2005-401-error

Anothing thing you could try: CrissCross generally works better if it is actually running on the same server as SSRS, see here:

http://crisscross.codeplex.com/wikipage?title=Impersonation Mode

If you want to keep CrissCross on a different server, then the 'Fixed user mode' instructions at the bottom of that page may help.

Let me know how you get on