We help IT Professionals succeed at work.

Replication error 14151

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!
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2012
Commented:
I would suspect the account you are using to connect the publisher to the subscriber no longer has access.

Author

Commented:
It's a domain admin account.  All of the other servers that rep to this one connect with it, so I don't think that's the issue.
CERTIFIED EXPERT
Top Expert 2012

Commented:
Than I am afraid I have no idea.
Okay, I found the solution.  Even though the SQL Browser showed that it was running and in automatic status, something must have goobered it up.  I restarted it and was able to get replication running again.

ACPerkins, thanks for trying to help.

Author

Commented:
ACPerkins, I'm awarding you 250 points for trying to help me.  Thanks!

Author

Commented:
My solution was the one that got replication running again.