> ## Documentation Index
> Fetch the complete documentation index at: https://rajanand.org/llms.txt
> Use this file to discover all available pages before exploring further.

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

### 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.

<Frame>
  ![image.png](https://cdn.hashnode.com/res/hashnode/image/upload/v1664528718025/hNEDqmKj8.png)
</Frame>

1. Verify the username and password and change it.

<Frame>
  ![image.png](https://cdn.hashnode.com/res/hashnode/image/upload/v1664528741637/ETiAG9FgV.png)
</Frame>

1. After the change, the log reader agent runs without an error.

<Frame>
  ![image.png](https://cdn.hashnode.com/res/hashnode/image/upload/v1664529203650/DjTlXWDfb.png)
</Frame>