Sign in
Microsoft.com
 
Resources for IT Professionals
 
 
 
Resources for IT Professionals > Dynamics Forums > CRM Development > Error 401 & CRM Connector for SSRS
Ask a questionAsk a question
Search Forums:
 

QuestionError 401 & CRM Connector for SSRS

  • Saturday, November 07, 2009 1:50 AMbittoo22 Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Has Code
    Sign In to Vote
    0
    Sign In to Vote
    Hi everyone,

    I just need a quick confirmation.
    My CRM Web Server & SQL Server are installed on different servers and I have a "401 Error" trying to run reports within CRM.
    Here is the error details:

    [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.bsg_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)
    

    
Error Number:

    
0x80040494

    and the request URL that generates the error is: http://MyCRMServer/CRMReports/rsviewer/reportviewer.aspx
    I checked I can't access the reportviewer.aspx file within IE...

    CRM is installed on CRMAppServer and both SQL Server (2005) & SSRS are installed on CRMSQLServer .

    On CRMAppServer , the registry key is correct and is: "http://CRMSQLServer /ReportServer/"

    i dont know where i m doing the silly mistake