We have been getting the following errors on our SQL 2008 R2 server several times a second.
I have searched the internet to its ends and I cannot find a solution that will work in our situation.
I have found several solutions online, but most of them will not work in our environment because we do not control the User objects in our AD.
Log Name: Application
Source: MSSQL$SPSQL
Date: 10/12/2012 7:33:33 AM
Event ID: 28005
Task Category: Server
Level: Error
Keywords: Classic
User: N/A
Computer: SQL Server
Description: An exception occurred while enqueueing a message in the target queue. Error: 15404, State: 19. Could not obtain information about Windows NT group/user 'DOMAIN\USER', error code 0x5.
Log Name: Security
Source: Microsoft-Windows-Security-Auditing
Date: 10/12/2012 7:35:26 AM
Event ID: 4625
Task Category: Logon
Level: Information
Keywords: Audit Failure
User: N/A
Computer: SQL Server
Description: An account failed to log on.
Subject:
Security ID: DOMAIN\SQL service account
Account Name: SQL service account
Account Domain: Domain
Logon ID:
Logon Type: 3
Account For Which Logon Failed:
Security ID: NULL SID
Account Name:
Account Domain:
Failure Information:
Failure Reason:
Unknown user name or bad password.
Status: 0xc000006d
Sub Status: 0xc0000064
Process Information:
Caller Process ID: 0x5d4
Caller Process Name: C:\Program Files\Microsoft SQL Server\MSSQL10_50.SPSQL\MSSQL\Binn\sqlservr.exe
Network Information:
Workstation Name:
SQL Server
Source Network Address:
Source Port: -
Detailed Authentication Information:
Logon Process: Authz
Authentication Package: Kerberos
Transited Services:-
Package Name (NTLM only):-
Key Length: 0
Thanks!
