MSSQL_ENG018456

THIS TOPIC APPLIES TO: yesSQL ServernoAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Message Details

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.

See Also

Errors and Events Reference (Replication)