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

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.
Categories: Debug
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: