Warning: I am a recruiter in SQL administration.
I set up a simple MSSQL replication running the server & # 39; 19 (developer edition).
The server and agent services run as local administrator on the machine.
I have created a small database with just a table and a few rows that I would like to replicate on the same server (just another database).
Distribution is configured to impersonate a service process account and snapshot sharing is just a local folder.
I have created a new transactional publication and set up all accounts to run as an agent account (or just impersonate).
Now, I added a subscription (push), choosing an empty database and configuring everything to run as an agent account or pretend to be the process account.
Checking the synchronization status will end in "Starting the agent". After a while, I'll get an error;
Agent 'XXXSRV1-Source-3' is retrying after an error. 4 retries attempted. See agent job history in the Jobs folder for more details.
But the verbose of this work is just that:
2019-12-12 13:42:56.651 Microsoft SQL Server Log Reader Agent 15.0.2000.5 2019-12-12 13:42:56.652 Copyright (c) 2016 Microsoft Corporation 2019-12-12 13:42:56.652 Microsoft SQL Server Replication Agent: logread 2019-12-12 13:42:56.653 2019-12-12 13:42:56.653 The timestamps prepended to the output lines are expressed in terms of UTC time. 2019-12-12 13:42:56.654 User-specified agent parameter values: -Publisher XXXSRV1 -PublisherDB Source -Distributor XXXSRV1 -DistributorSecurityMode 1 -Continuous -OutputVerboseLevel 2 -Output C:ReplOutput.txt -XJOBID 0xF855F65C5625C2439F8D41552D5F0C0C -XJOBNAME XXXSRV1-Source-3 -XSTEPID 2 -XSUBSYSTEM LogReader -XSERVER KNWORKSRV1 -XCMDLINE 0 -XCancelEventHandle 0000000000001A58 -XParentProcessHandle 0000000000001A80 2019-12-12 13:42:56.661 Status: 0, code: 20015, text: ''. 2019-12-12 13:42:56.662 Disconnecting from OLE DB ''
Could someone give us more information?