Transactional Replication : Log Reader Agent was unable to connect to the Publisher using the specified login

SQL Server Agent is running with Windows Credential with no roles assigned. Behind the scene Log Reader Agent Connect to the Publisher Database to read database log, master  and resource database to obtain license and version information. As we have not granted any sort of permission to the Agent Account at the publisher server ,so it fails with below error.

Error :

Error : “2014-11-11 03:09:04.073 Status: 0, code: 22040, text: ‘The Log Reader Agent was unable to connect to the Publisher using the specified login. Make sure that the login used by the agent is a member of either the sysadmin fixed server role at the Publisher or the db_owner fixed database role in the publication database. ‘.

2014-11-11 03:09:04.073 The Log Reader Agent was unable to connect to the Publisher using the specified login. Make sure that the login used by the agent is a member of either the sysadmin fixed server role at the Publisher or the db_owner fixed database role in the publication database.”

 

Solution :

  1. Grant SysAdmin Server Role to the agent account
  2. Grant DB_Owner to the Agent Account on Publisher and master database.

Leave a Reply

Your email address will not be published. Required fields are marked *