MSSQLSERVER_15404
Applies to: SQL Server
Details
Attribute | Value |
---|---|
Product Name | SQL Server |
Event ID | 15404 |
Event Source | MSSQLSERVER |
Component | SQLEngine |
Symbolic Name | SEC_NTGRP_ERROR |
Message Text | Could not obtain information about Windows NT group/user 'user', error code code. |
Explanation
15404 is used in authentication when an invalid principal is specified. Or, impersonation of a Windows account fails because there is no full trust relationship between the SQL Server service account and the domain of the Windows account.
User Action
Check that the Windows principal exists and is not misspelled.
If this error is the result of a lack of a full trust relationship between the SQL Server service account and the domain of the Windows account, one of the following actions can resolve the error:
Use an account from the same domain as the Windows user for the SQL Server service.
If SQL Server is using a machine account such as Network Service or Local System, the machine must be trusted by the domain containing the Windows User.
Use a SQL Server account.