Error message "Could not obtain information about Windows NT group/user error code 0x5 Error 15404" while running Report Data Synchronization Job.

Products

• Control Compliance Suite Windows

Issue/Introduction

Error message "Could not obtain information about Windows NT group/user error code 0x5 Error 15404" while running Report Data Synchronization Job.

Resolution

This message is thrown if the SQL Server service uses an account that does not have sufficient administrative credentials on the Windows domain. In this situation, the xp_logininfo system stored procedure is run by using the security context of the SQL Server service. Because the account does not have sufficient administrative credentials to enumerate the properties of the user in the domain, the xp_logininfo system stored procedure fails, and you receive the 8198 error. To resolve this problem, change the startup account of the SQL Server service to a Windows domain account.

We need to either run the SQL service under domain account or use SQL authentication