<h3 id="heading-error">Error:</h3>
<p>Log reader agent has failed with an error </p>
<blockquote>
<p>Login failed for user 'sql-user-account'.</p>
</blockquote>
<h3 id="heading-solution">Solution:</h3>
<ol>
<li>Right click on the publication name and open <code>properties</code> window.</li>
<li>Go to <code>Agent Security</code> page and select <code>Security Settings</code> of log reader agent. If the issue in Snapshot agent, select the <code>Security Settings</code> of snapshot agent.
<img src="https://cdn.hashnode.com/res/hashnode/image/upload/v1664528718025/hNEDqmKj8.png" alt="image.png" class="image--center mx-auto" /></li>
<li>Verify the username and password and change it.
<img src="https://cdn.hashnode.com/res/hashnode/image/upload/v1664528741637/ETiAG9FgV.png" alt="image.png" class="image--center mx-auto" /></li>
<li>After the change, the log reader agent runs without an error.
<img src="https://cdn.hashnode.com/res/hashnode/image/upload/v1664529203650/DjTlXWDfb.png" alt="image.png" class="image--center mx-auto" /></li>
</ol>


### 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.
1. 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](https://cdn.hashnode.com/res/hashnode/image/upload/v1664528718025/hNEDqmKj8.png align="center")
1. Verify the username and password and change it.
![image.png](https://cdn.hashnode.com/res/hashnode/image/upload/v1664528741637/ETiAG9FgV.png align="center")
1. After the change, the log reader agent runs without an error.
![image.png](https://cdn.hashnode.com/res/hashnode/image/upload/v1664529203650/DjTlXWDfb.png align="center")


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

I'm a Business Intelligence Developer with over a decade of experience in design and development of databases, data warehouse, ETL, business intelligence reports and data visualization/analytics.


I am a Business intelligence lead with over a decade of experience in building DW/BI solutions. I am a Microsoft Certified Solutions Expert in Data management &amp; analytics and trainer.