Solved

Replication error 14151

Posted on 2012-03-12
6
1,459 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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

679 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