Solved

Replication error 14151

Posted on 2012-03-12
6
1,396 Views
Last Modified: 2012-06-21
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!
0
Comment
Question by:Clothahump
  • 4
  • 2
6 Comments
 
LVL 75

Assisted Solution

by:Anthony Perkins
Anthony Perkins earned 250 total points
ID: 37712816
I would suspect the account you are using to connect the publisher to the subscriber no longer has access.
0
 
LVL 4

Author Comment

by:Clothahump
ID: 37715086
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.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 37717681
Than I am afraid I have no idea.
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 4

Accepted Solution

by:
Clothahump earned 0 total points
ID: 37729812
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.
0
 
LVL 4

Author Comment

by:Clothahump
ID: 37737333
ACPerkins, I'm awarding you 250 points for trying to help me.  Thanks!
0
 
LVL 4

Author Closing Comment

by:Clothahump
ID: 37760252
My solution was the one that got replication running again.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question