Hi guys,
I have read quite a few topics dealing with issues similar to the one I'm having, however none of the solutions worked for me... Here are a couple of things I tried:
http://support.microsoft.com/kb/950416 http://social.microsoft.com/Forums/en-US/crm/thread/443eda5d-b5b4-4cee-99d3-5170b9882b49 http://blog.customereffective.com/blog/2009/06/troubleshooting-crm-authentication-on-windows-server-2008.html http://social.microsoft.com/Forums/en-US/crmdeployment/thread/ccf10f23-989f-4a86-8849-648c6affe4bd http://social.microsoft.com/Forums/en-US/crm/thread/05115db0-12e3-45c8-8f64-b80efc3d2ed2 http://ronaldlemmen.blogspot.com/2009/04/401-unauthorized-when-accessing.html ...
My CRM server is running Windows 2008 Server SP2 and I installed CRM 4.0 with update rollup 6 on it from scratch (no update from CRM 3.0). It's using a SQL 2008 Server.
Below is the error I get in the CrmAsyncService log file.
You will notice that the Organization ID is 000.. and so is the User ID, which makes me bend towards an impersonation issue (trying to use the MSCRM web service as an anonymous user), but I can't find out what setting I could have missed.
Any thoughts?
[2009-10-06 19:07:02.9] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 19(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.ExecuteNonQuery
at CrmDbConnection.ExecuteNonQuery(IDbCommand command, Boolean impersonate)
at DataAccessSharedBase.ExecuteSqlCommand(IDbCommand command, Nullable`1 expectedAffectedRecords)
at QueueDataAccess.UpdateStateAndStatusInternal(Guid eventId, Int32 newState, Int32 newStatus, DateTime nextOccurrence, Boolean retryOperation, Int32 currentRetryCount, Int32 errorCode, String errorMessage, Boolean clearData, Boolean removeEvent, Int32 operationType)
at UpdateStateAndStatusCommand.InternalExecute()
at QueuedDatabaseCommand.Execute(QueueManager queueManager)
at QueueManager.ExecuteAllOutstandingDatabaseOperations()
at QueueManager.OnDatabaseOperationTimerEvent(Object sender, ElapsedEventArgs e)
at TimerProcessor.ExecuteTimers(Object data)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>update AsyncOperationBase
set
StateCode = 1
, StatusCode = 10
, ErrorCode = -2147204346
, Message = 'System.Net.WebException: The request failed with HTTP status 401: Unauthorized.
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.Crm.SdkTypeProxy.CrmService.Execute(Request Request)
at Microsoft.Crm.Asynchronous.SdkTypeProxyCrmServiceWrapper.Execute(Object request)
at Microsoft.Crm.Asynchronous.UserSettingsCacheLoader.RetrieveUserSettings(ICrmService crmService, Guid userId)
at Microsoft.Crm.Asynchronous.UserSettingsCacheLoader.LoadCacheData(Guid userId, IOrganizationContext context)
at Microsoft.Crm.Caching.BasicCrmCache`2.CreateEntry(TKey key, IOrganizationContext context)
at Microsoft.Crm.Caching.BasicCrmCache`2.LookupEntry(TKey key, IOrganizationContext context)
at Microsoft.Crm.Asynchronous.ImportOperation.GetUserLanguage(AsyncEvent asyncEvent)
at Microsoft.Crm.Asynchronous.ImportOperation.InternalExecute(AsyncEvent asyncEvent)
at Microsoft.Crm.Asynchronous.AsyncOperationCommand.Execute(AsyncEvent asyncEvent)
at Microsoft.Crm.Asynchronous.QueueManager.PoolHandler.ProcessAsyncEvent(AsyncEvent asyncEvent)'
, PostponeUntil = '12/30/9999 23:59:59'
, ModifiedOn = DATEADD(MILLISECOND, -1*DATEPART(MILLISECOND, GETUTCDATE()), GETUTCDATE())
, ModifiedBy = CreatedBy
where AsyncOperationId = '2f0cfbcc-98b2-de11-92e2-005056b8747c'
