MS CRM 4.0 & SSRS 2008 - The request failed with HTTP status 401: Unauthorized RRS feed

  • Question

  • Hi All,

    We are having the following error on our MS CRM 4.0 Server. Our CRM server is separate from SQL Server and SSRS. SQL and SSRS is on one server. Installed SSRS Data Connector. All servers are on RU17.


    Event code: 3005
    Event message: An unhandled exception has occurred.
    Event time: 15/02/2012 23:07:11
    Event time (UTC): 15/02/2012 23:07:11
    Event ID: c11a0156fe4c472dbb62763566710d2a
    Event sequence: 853890
    Event occurrence: 19
    Event detail code: 0

    Application information:
    Application domain: /LM/W3SVC/1/ROOT-1-129737448006124716
    Trust level: Full
    Application Virtual Path: /
    Application Path: C:\inetpub\wwwroot\
    Machine name: (removed)

    Process information:
    Process ID: 5328
    Process name: w3wp.exe
    Account name: domain\serviceaccount

    Exception information:
    Exception type: WebException
    Exception message: The request failed with HTTP status 401: Unauthorized.

    Request information:
    Request URL: https://mscrm.com:443/Reserved.ReportViewerWebControl.axd?ReportSession=zttkc455lyisit45jevdrfqp&ControlID=50e87274e6954ca890825c7f10c9aef4&Culture=1033&UICulture=1033&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodreportViewerTouchSession0&CacheSeed=Wed%20Feb%2015%2017%3A07%3A09%202012
    Request path: /Reserved.ReportViewerWebControl.axd
    User host address: (removed)
    User: domain\user (changed)
    Is authenticated: True
    Authentication Type: Negotiate
    Thread account name: domain\serviceaccount 

    Thread information:
    Thread ID: 15
    Thread account name: domain\serviceaccount
    Is impersonating: True
    Stack trace: at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
    at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
    at Microsoft.SqlServer.ReportingServices2005.Execution.ReportExecutionService.GetExecutionInfo()
    at Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.GetExecutionInfo()
    at Microsoft.Reporting.WebForms.ServerReport.TouchSession()
    at Microsoft.Reporting.WebForms.SessionKeepAliveOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
    at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
    at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
    at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

    We are not using Kerberos and we are having the following error, is this related to the error above?


    A Kerberos Error Message was received:
    on logon session
    Client Time:
    Server Time: 23:19:7.0000 2/15/2012 Z
    Extended Error: 0xc0000035 KLIN(0)
    Client Realm:
    Client Name:
    Server Realm: DIR.COM
    Server Name: HTTP/mscrm.com
    Target Name: HTTP/mscrm.com@DIR.COM
    Error Text:
    File: 9
    Line: efb
    Error Data is in record data.

    Note: I changed the Server and domain account names for security purposes.

    Thursday, February 16, 2012 9:38 AM

All replies

  • Hi
     Looks like its a double hob Authentication problem
      this is common problem with split server setup if kerberos is not setup correct
     Read thru this article and follow the step ,


    If the problem is resolved, we would appreciate a post explaining the resolution and mark the post answered and close the thread.

    Thursday, February 16, 2012 10:05 AM
  • Thanks for the reply. I forgot to mention that the reports are working but the above errors are being logged and might be related to our other issue with SSRS, http://social.msdn.microsoft.com/Forums/en-US/crm/thread/712e34a7-c916-472a-a317-76069bc1731d.

    library!ReportServer_0-8!1c08!01/19/2012-20:03:51:: i INFO: RenderForNewSession('/Live_MSCRM/4.0/{C361BEF7-7DDB-E011-A9BB-0026B9FCB114}')
    webserver!ReportServer_0-8!1c08!01/19/2012-20:03:52:: i INFO: Processed report. Report='/Live_MSCRM/4.0/{C361BEF7-7DDB-E011-A9BB-0026B9FCB114}', Stream=''
    library!ReportServer_0-8!2018!01/19/2012-20:06:48:: i INFO: RenderFromSession('/Live_MSCRM/4.0/{C361BEF7-7DDB-E011-A9BB-0026B9FCB114}')
    webserver!ReportServer_0-8!2018!01/19/2012-20:06:48:: i INFO: Processed report. Report='/Live_MSCRM/4.0/{C361BEF7-7DDB-E011-A9BB-0026B9FCB114}', Stream=''
    library!ReportServer_0-8!1a18!01/19/2012-20:07:11:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidItemPathException: , Microsoft.ReportingServices.Diagnostics.Utilities.InvalidItemPathException: The path of the item '/Live_MSCRM/4.0/' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash.;

    Is these are related issues?

    Thursday, February 16, 2012 12:01 PM