Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 Replication error 14151
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

18 Posts

Posted - 03/14/2012 :  12:54:53  Show Profile  Reply with Quote
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!


5072 Posts

Posted - 03/14/2012 :  14:00:07  Show Profile  Visit russell's Homepage  Reply with Quote
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.
Go to Top of Page


5072 Posts

Posted - 03/14/2012 :  14:08:04  Show Profile  Visit russell's Homepage  Reply with Quote
Might also want to see these:'

Almost forgot -- make sure the repl_distributor linked servers are setup and properly configured too.

Edited by - russell on 03/14/2012 14:09:38
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000