Aug 9, 2012

An exception occurred while enqueueing a message in the target queue. Error: 15404, State: 19. Could not obtain information about Windows NT group/user , error code 0x5

If you get this error with SharePoint and SQL Server filling up your SQL logs, try the following:

1. Check which user account is configured as the Service Account for your SQL Server instance.

2. Confirm in your Active Directory that the security object "NT Authority\Authenticated Users" have Read permission on your service account.  
  a.  Open  "Active Directory Users & Computers" on a Windows Server with admin permissions
  b. Active "Advanced features" in the View menu
  c. Right click the service user account and choose Properties
  d. Go to the Security tab and click on "Authenticated users" (If it doesn't exist, add it)
3. If the account is NTAuthority\NetworkService, change it to a regular domain account "yourdomain\yoursqlserviceuser" and restart the SQL Server service

4. Change the service account back to NTAuthority\NetworkService and restart the SQL Server service

5. Check if the error still appears.

Important:  The best practice is to use a regular domain account as the service account for SQL Server to avoid problems such as SQL backups across networks.

No comments:

Post a Comment