Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

MSSQL_ENG018456

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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

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.

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

Community Additions

ADD
Show:
© 2015 Microsoft