Event Id18456
SourceMSSQL_ENG
DescriptionLogin failed for user %.*ls.%.*ls
Event InformationAccording to Microsoft

Cause:

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.

NOTE:In versions prior to Microsoft SQL Server 2000 Service Pack 3 (SP3), it was possible to specify that this connection was trusted and did not require a password. If you are upgrading from a previous version, you must now specify a password.

Resolution:

Ensure that you have specified a password for this account.
Reference LinksEvent ID 18456 of Source MSSQL_ENG


  Did this information help you to resolve the problem?
  Yes: My problem was resolved.
  No: The information was not helpful / Partially helpful.
  Comments:

Captcha  Refresh