MSSQL_ENG018456

Applies to: SQL Server Azure SQL Managed Instance

Message Details

Attribute	Value
Product Name	SQL Server
Event ID	18456
Event Source	MSSQLSERVER
Component	SQL Server Database Engine
Symbolic Name
Message Text	Login failed for user '%.*ls'.%.*ls

Explanation

Error MSSQL_ENG018456 is raised whenever a login attempt fails. If the error message includes the account distributor_admin (Login failed for user 'distributor_admin'.), the issue is with an account used by replication. Replication creates a remote server, repl_distributor, which allows communication between the Distributor and Publisher. The login distributor_admin is associated with this remote server and must have a valid password.

User Action

Ensure that you have specified a password for this account. For more information, see Secure the Distributor.

Related content

• Errors and Events Reference (Replication)