Status: 0, code: 20015 on Log Reader

Question

Hello
I am getting the above error whenever I am setting up SQL Replication for a Cluster to a stand alone machine

Here are a couple of points - the log reader account is a windows account that is a sql admin on both the publisher and the subscriber
I have configured the distributor to use the Publication
I have for bonus point (and a last ditch effort) included the accounts into the PAL

The full error I am getting on the Log reader is this

2021-06-10 22:49:25.689 User-specified agent parameter values:
-Publisher XXXXXXXXXXXXXX
-PublisherDB XXXXXXXXXXXXXXX
-Distributor XXXXXXXXXXXXXXX
-DistributorSecurityMode 1
-Continuous
-XJOBID 0xACC08AC80EC7124AA212527AEB2A6268
-XJOBNAME XXXXXXXXXXXXXXXXX
-XSTEPID 2
-XSUBSYSTEM LogReader
-XSERVER XXXXXXXXXXXXXXX
-XCMDLINE 0
-XCancelEventHandle 0000000000002040
-XParentProcessHandle 0000000000001D40
2021-06-10 22:49:25.689 Status: 0, code: 20015, text: ''.

Can anyone tell me where to look or what to check ?

Thanks
Peter

Answer 1

Hi @Peter Nolan ,

> 2021-06-10 22:49:25.689 Status: 0, code: 20015, text: ''.

Please share us the message around the error message in log reader agent job history. The message that you offered is too less for analysis.

Is this a transaction replication? Any other error message that you got from replication monitor? Where in the synchronization process is replication failing? Which agent is experiencing an error? Only log reader agent job failed?

Please read MS document Troubleshooter: Find errors with SQL Server transactional replication, this help you collect message for analysis.

> I am setting up SQL Replication for a Cluster to a stand alone machine

Did you mean the publisher on cluster instance, the subscriber on standard alone instance? If I misunderstood, please let me know. And please descript your environment more clearly.

---

If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.