Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Clothahump
Starting Member
18 Posts |
 Posted - 2012-03-14 : 12:54:53
|
| 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! |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-03-14 : 14:00:07
|
| This is a transactional publication?Push or pull?Where does the distrubitor live (on publisher, on subscriber, dedicated machine)?In the Distribution job, what is the value of the -DistributionSecurityMode switch?If 0, check the account that is being used for the distribution agent. Make sure it isn't locked out, disabled etc. And that it has permissions to connect to publisher/distributor/subscriber.If 1, verify that account and password are correct, and the same other stuff as above.What errors do you see in the Windows Application Event Logs? (eventvwr.exe)Also check SQL Server logs (on distributor) and msrepl_errors on distributor. |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-03-14 : 14:08:04
|
| Might also want to see these:http://msdn.microsoft.com/en-us/library/ms147328.aspxhttp://msdn.microsoft.com/en-us/library/ms147827.aspx'Almost forgot -- make sure the repl_distributor linked servers are setup and properly configured too. |
|
|
|
|
|
|
Replication error 14151