iam using sql server 2016 and i have followed MSDN tutorial in order to configure replication between two nodes the first one is the publisher and distributor
while the second one is the subscriber
but when i issue View Synchronization status the job hangs
and in order to know the reason i tried to run launch replication monitor and inserted a token which showsthat
publisher to distributor takes one second while it hangs as pending from distributor to subscriber
and showsthe following error Agent 'Node1-ReplicatedDataBase-PublicationName-Node2' is retrying after an error. 18 retries attempted. See agent job history in the Jobs folder for more details.
so I issued the following query to know the exact reason
SELECT J.[name] ,[step_name] ,[message] ,[run_status] ,[run_date] ,[run_time] ,[run_duration] FROM [msdb].[dbo].[sysjobhistory] JH JOIN [msdb].[dbo].[sysjobs] J ON JH.job_id= J.job_id order by run_date desc ,run_time desc
and it shows the following error
Unable to start execution of step 2 (reason: Error authenticating proxy Node1\repl_distribution, system error: The user name or password is incorrect.)
even though i have configured distributor in subscriber with this account with the right password
i noticed also that after restarting sql server agent on Node1 the job Replication monitoring refresher for distribution has x mark which refers that it doesn't work
any ideas please to what could be the reason ?