SQLServer Replication The process could not connect to Distributor .

• lianvh 89542

  SSCommitted

  Points: 1561

  More actions

  June 27, 2013 at 1:31 am

  #295084

  Good Day. We configured Pull Replication and I checked the number of rows being stored in the replicated tables and they are the numbers match. But when I look at the properties of the subscriptions , the abovementioned message is dispalyed. We use SQL Server Security . I was even able to sign onto the Distributor database using the same account. The account has all the required permissions and there is no entry in SQL's log that there are failed logins . Any ideas ?

• WolfgangE

  SSCertifiable

  Points: 6328

  More actions

  June 28, 2013 at 11:09 am

  #1628363

  Only one idea: did the password of the user change? If so you will have to update all the replication agents with the new password.

  But, it could also be, that the subscriber instance cannot reach the distributor. Go to the subscriber direclty and try a PING to the distributor.