SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

Clothahump
Starting Member

USA
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!

russell
Pyro-ma-ni-yak

USA
5071 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

russell
Pyro-ma-ni-yak

USA
5071 Posts

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

http://msdn.microsoft.com/en-us/library/ms147328.aspx

http://msdn.microsoft.com/en-us/library/ms147827.aspx'

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  
 New 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.09 seconds. Powered By: Snitz Forums 2000