Rajanand Ilangovan
Rajanand's Blog

Follow

Rajanand's Blog

Follow

How to fix Log reader agent login failure in SQL Server replication?

Rajanand Ilangovan's photo
Rajanand Ilangovan
·Sep 30, 2022·

1 min read

Error:

Log reader agent has failed with an error

Login failed for user 'sql-user-account'.

Solution:

  1. Right click on the publication name and open properties window.
  2. Go to Agent Security page and select Security Settings of log reader agent. If the issue in Snapshot agent, select the Security Settings of snapshot agent. image.png
  3. Verify the username and password and change it. image.png
  4. After the change, the log reader agent runs without an error. image.png