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

as mentioned in this link https://docs.microsoft.com/en-us/sql/relational-databases/replication/tutorial-replicating-data-between-continuously-connected-servers?view=sql-server-2017

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 ?

0 Answers