Solved

Replication error 14151

Posted on 2012-03-12
6
1,548 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

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…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

617 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