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

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.
Description:
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\serviceaccountException 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?
Description:
A Kerberos Error Message was received:
on logon session
Client Time:
Server Time: 23:19:7.0000 2/15/2012 Z
Error Code: 0x7 KDC_ERR_S_PRINCIPAL_UNKNOWN
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 ,http://dotnetrobert.com/?q=node/36
hth
dkay
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