How to fix Log reader agent login failure in SQL Server replication?
·Sep 30, 2022·
1 min read
Log reader agent has failed with an error
Login failed for user 'sql-user-account'.
- Right click on the publication name and open
- Go to
Agent Securitypage and select
Security Settingsof log reader agent. If the issue in Snapshot agent, select the
Security Settingsof snapshot agent.
- Verify the username and password and change it.
- After the change, the log reader agent runs without an error.