question

PeterNolan-8796 avatar image
0 Votes"
PeterNolan-8796 asked Cathyji-msft commented

Status: 0, code: 20015 on Log Reader

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

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @PeterNolan-8796,

Any update for this thread? We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it is not, please let us know. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

0 Votes 0 ·

1 Answer

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered

Hi @PeterNolan-8796,

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.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.