Replication error started recently on a previously working system. Both servers running SQL 2005, in the same domain, both logged in using the same domain admin service account. I have rebooted both servers and have completely rebuilt the replication process from the ground up, with no joy.
The distribution database gives this error message (14151) every time the repl. agent job runs:
Replication-Replication Distribution Subsystem: agent HOU-CX-01-CT-ca_tables-HOU-SQL02-5 failed. The process could not connect to Subscriber 'HOU-SQL02'.
I can ping the subscriber system with no problem.
Thanks in advance for any help!