locked
CRM 4.0 Reporting Error RRS feed

  • Question

  • I am facing following technical issue in CRM multi server deployment. Where CRM & (SQL DB + SRS ) machines are operating. Details are below. Please recommend some solution. 
     
     
    Current deployment Scenario with error details
     
    64 bit Virtual Box A                 CRM Application Server  (roll up 14) 
    64 bit Physical Box B               MSSQL DB Named server with Reporting Service of named instance, with  SQL  Connector for CRM )  (roll up 14)
    Box C  Domain Controller        Windows Server 2008 64bit environment

            
    Reports are working fine in reports manager but through CRM 4.0. I am only able to run reports by installation user on CRM sever machine. By any other user or any other machine even installation user unable to run reports and receving the following error,
     
     
    Microsoft CRM Error Report:
    Error Description:
    The request failed with HTTP status 401: Unauthorized.
    Error Details:
    The request failed with HTTP status 401: Unauthorized.
    Full Stack:
    [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 Microsoft.Crm.Web.Reporting.SrsReportViewer.ConfigurePage()
    [CrmReportingException: The request failed with HTTP status 401: Unauthorized.]
       at Microsoft.Crm.Web.Reporting.SrsReportViewer.ConfigurePage()
       at Microsoft.Crm.Application.Controls.AppUIPage.OnPreRender(EventArgs e)
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
    [HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown.]
       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.inbox_crmreports_rsviewer_reportviewer_aspx.ProcessRequest(HttpContext context)
       at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
       at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
     
    Other Message:
    Error Number:
    0x80040494
    Source File:
    Not available
    Line Number:
    Not available
     
     
    Date: 12-21-2010
    Time: 09:44:23
    Server: crmlive
     
    Monday, December 27, 2010 10:57 AM

Answers