I apologize for the length of this post but this is something at is becoming a royal pain in the you know what.
We have a Windows 2008 Server that is running two virtual servers 2003 one for CRM one for SQL 2005. I set this up and moved our existing deployment from some inferior hardware to this deployment following steps I could find in the CRM deployment documentation and suggestions from various internet sources. So it is entirely possible I missed something.
On a fairly regular basis(almost daily) we have to reboot the CRM server do to receiving the following error (I'm posting only part of the error due to the length of it. Up until this point everything for works fine in CRM throughout the day and during the day after the reboot.
*************************************************
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
*************************************************
If I look in the CRM server application event viewer they are many warnings of
**********************************************************************
Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 3/9/2010
Time: 5:51:15 AM
User: N/A
Computer: CANNON
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 3/9/2010 5:51:15 AM
Event time (UTC): 3/9/2010 10:51:15 AM
Event ID: ad74bc949ded438db5a9fb785da95760
Event sequence: 272
Event occurrence: 271
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/2/ROOT-1-129126024099599044
Trust level: Full
Application Virtual Path: /
Application Path: C:\Program Files\Microsoft Dynamics CRM\CRMWeb\
Machine name: CANNON
Process information:
Process ID: 5048
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Exception information:
Exception type: SqlException
Exception message: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
Request information:
Request URL: http://cannon:5555/MSCRMServices/2007/CrmService.asmx
Request path: /MSCRMServices/2007/CrmService.asmx
User host address: 192.168.168.200
User: IBS\jbock
Is authenticated: True
Authentication Type: Negotiate
Thread account name: NT AUTHORITY\NETWORK SERVICE
Thread information:
Thread ID: 5
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: True
Stack trace: at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.Crm.CrmDbConnection.Open()
at Microsoft.Crm.SharedDatabase.DatabaseMetadata.LoadMetadataXmlFromDatabase(CrmDBConnectionType connectionType, String connectionString, Int32& maxBlobSize)
at Microsoft.Crm.SharedDatabase.DatabaseMetadata.LoadCacheFromDatabase(CrmDBConnectionType connectionType, String connectionString)
at Microsoft.Crm.ConfigurationDatabase.ConfigurationMetadata.LoadCache()
at Microsoft.Crm.ConfigurationDatabase.ConfigurationMetadata.get_Cache()
at Microsoft.Crm.ConfigurationDatabase.ConfigurationDatabaseService.InitializeMetadataCache()
at Microsoft.Crm.SharedDatabase.DatabaseService.Initialize(String tableName)
at Microsoft.Crm.SharedDatabase.DatabaseService.Retrieve(String tableName, String[] columns, PropertyBag[] conditions)
at Microsoft.Crm.ServerLocatorService.GetSiteSettingIdFromDatabase()
at Microsoft.Crm.ServerLocatorService.GetSiteSettingId()
at Microsoft.Crm.ServerLocatorService.GetSiteSetting(String settingName)
at Microsoft.Crm.CrmTrace.get_RefreshTrace()
Custom event details:
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
************************************************
If I look at the SQL Server event log I see corresponding
****************************************************
Event Type: Failure Audit
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 18456
Date: 3/9/2010
Time: 5:34:09 AM
User: NT AUTHORITY\ANONYMOUS LOGON
Computer: DARTMOUTH
Description:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [CLIENT: 192.168.168.113]
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
******************************************************************
The 192.168.168.113 is the IP address of the CRM server. My guess is I don't have something set up correctly on the SQL server for the CRM server to access the database, or something wrong in the set up on the CRM server in IIS but I've looked again on the good old WWW and can't find any point of direction.
Thanks in advance
John
