Otdfbt

Multi tool use

Why did the Apollo 13 crew extend the LM landing gear?

Is there an idiom that support the idea that "inflation is bad"?

On which topic did Indiana Jones write his doctoral thesis?

Why is B♯ higher than C♭ in 31-ET?

How do I tell my manager that his code review comment is wrong?

How can I close a gap between my fence and my neighbor's that's on his side of the property line?

Should I mention being denied entry to UK due to a confusion in my Visa and Ticket bookings?

Can Infinity Stones be retrieved more than once?

BOOM! Perfect Clear for Mr. T

Independent, post-Brexit Scotland - would there be a hard border with England?

Make some Prime Squares!

Can my company stop me from working overtime?

Will 700 more planes a day fly because of the Heathrow expansion?

Why do money exchangers give different rates to different bills?

Why is Arya visibly scared in the library in S8E3?

What was the first instance of a "planet eater" in sci-fi?

What to use instead of cling film to wrap pastry

Getting a W on your transcript for grad school applications

How do LIGO and VIRGO know that a gravitational wave has its origin in a neutron star or a black hole?

Would glacier 'trees' be plausible?

Are there any Final Fantasy Spirits in Super Smash Bros Ultimate?

Verb "geeitet" in an old scientific text

How do I make a function that generates nth natural number that isn't a perfect square?

Why do people keep telling me that I am a bad photographer?

SQL 2008 R2 replication error: The process could not connect to Distributor

SQL 2008 Replication over InternetSQL Transactional Replication snapshot not applyingReplication between SQL 2008 & SQL 2000 - Across network (DMZ) - process could not connect to SubscriberTable modifications while running db replication (MS SQL 2008)Adding new article to transactional replication gives error at subscriberSQL Server 2008 - Performance impact of transactional replication?SQL Server 2008 Chaining Merge ReplicationUsing a subscriber database as a backupHow to move the files of a replicated database (SQL Server 2008 R2) to a different driveIf a SQL Server Replication Distributor and Subscriber are on the same server, should a PUSH or PULL subsciption be used?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

1

I have two servers running SQL 2008 R2 Standard, each with an instance named "MAIN". I have a small test database on my primary server (one table, 13 rows) that I want to replicate to a second server as a proof-of-concept for some larger databases that I want to replicate. I set up the primary server to be a publisher and distributor, and set the database to do transactional replication. I copied the data to the second server via a backup/restore, not via a snapshot (which I'll have to do with the larger databases due to database size and limited bandwidth). I followed the instructions here:
http://gnawgnu.blogspot.com/2009/11/sql-2008-transactional-replication-and.html

Now on the subscriber, I go under Replication / Local Subscriptions / Right click / Properties on my subscription to the DB. The status of the last synchronization shows a status of: "The process could not connect to Distributor 'PRIMARYSERVERMAIN'."

Data IS replicating from the primary to the secondary. Any record I add on the primary shows up on the secondary server within seconds.

Is the Distributor part of the Snapshot system that I'm not using, or is it part of the transaction replication stuff?

Thanks,
Lance

sql-server-2008 replication transactional-replication

share|improve this question

edited Mar 11 '11 at 1:22

Lance Lefebure

asked Feb 14 '11 at 21:13

Lance LefebureLance Lefebure

11326

add a comment | 

1

I have two servers running SQL 2008 R2 Standard, each with an instance named "MAIN". I have a small test database on my primary server (one table, 13 rows) that I want to replicate to a second server as a proof-of-concept for some larger databases that I want to replicate. I set up the primary server to be a publisher and distributor, and set the database to do transactional replication. I copied the data to the second server via a backup/restore, not via a snapshot (which I'll have to do with the larger databases due to database size and limited bandwidth). I followed the instructions here:
http://gnawgnu.blogspot.com/2009/11/sql-2008-transactional-replication-and.html

Now on the subscriber, I go under Replication / Local Subscriptions / Right click / Properties on my subscription to the DB. The status of the last synchronization shows a status of: "The process could not connect to Distributor 'PRIMARYSERVERMAIN'."

Data IS replicating from the primary to the secondary. Any record I add on the primary shows up on the secondary server within seconds.

Is the Distributor part of the Snapshot system that I'm not using, or is it part of the transaction replication stuff?

Thanks,
Lance

sql-server-2008 replication transactional-replication

share|improve this question

edited Mar 11 '11 at 1:22

Lance Lefebure

asked Feb 14 '11 at 21:13

Lance LefebureLance Lefebure

11326

add a comment | 

I have two servers running SQL 2008 R2 Standard, each with an instance named "MAIN". I have a small test database on my primary server (one table, 13 rows) that I want to replicate to a second server as a proof-of-concept for some larger databases that I want to replicate. I set up the primary server to be a publisher and distributor, and set the database to do transactional replication. I copied the data to the second server via a backup/restore, not via a snapshot (which I'll have to do with the larger databases due to database size and limited bandwidth). I followed the instructions here:
http://gnawgnu.blogspot.com/2009/11/sql-2008-transactional-replication-and.html

Now on the subscriber, I go under Replication / Local Subscriptions / Right click / Properties on my subscription to the DB. The status of the last synchronization shows a status of: "The process could not connect to Distributor 'PRIMARYSERVERMAIN'."

Data IS replicating from the primary to the secondary. Any record I add on the primary shows up on the secondary server within seconds.

Is the Distributor part of the Snapshot system that I'm not using, or is it part of the transaction replication stuff?

Thanks,
Lance

sql-server-2008 replication transactional-replication

share|improve this question

edited Mar 11 '11 at 1:22

Lance Lefebure

asked Feb 14 '11 at 21:13

Lance LefebureLance Lefebure

11326

share|improve this question

edited Mar 11 '11 at 1:22

Lance Lefebure

asked Feb 14 '11 at 21:13

Lance LefebureLance Lefebure

11326

share|improve this question

edited Mar 11 '11 at 1:22

Lance Lefebure

asked Feb 14 '11 at 21:13

Lance LefebureLance Lefebure

11326

asked Feb 14 '11 at 21:13

Lance LefebureLance Lefebure

11326

asked Feb 14 '11 at 21:13

Lance LefebureLance Lefebure

11326

2 Answers
2

active

oldest

votes

0

Check whether Browser services is running all SQL instance.
Are you using a named instance?
Also see if there are an resource jobs are running.

share|improve this answer

answered May 12 '11 at 14:33

Satya SKJSatya SKJ

393

add a comment | 

0

The distributor is what is recording the changes from the publisher and queueing them before they are sent to the subscriber.

The default is to do a push subscription where no connectivity is needed from the subscriber to the distributor as the connection goes from the distributor to the subscriber. That being the case I'm guessing that there's a firewall blocking either UDP port 1434 on the publisher, or there's a firewall blocking the TCP port that the named instance on PRIMARYSERVER is listening on.

share|improve this answer

answered Mar 4 '13 at 20:58

mrdennymrdenny

26.4k43466

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "2"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f235444%2fsql-2008-r2-replication-error-the-process-could-not-connect-to-distributor%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

Check whether Browser services is running all SQL instance.
Are you using a named instance?
Also see if there are an resource jobs are running.

share|improve this answer

answered May 12 '11 at 14:33

Satya SKJSatya SKJ

393

add a comment | 

0

Check whether Browser services is running all SQL instance.
Are you using a named instance?
Also see if there are an resource jobs are running.

share|improve this answer

answered May 12 '11 at 14:33

Satya SKJSatya SKJ

393

add a comment | 

Check whether Browser services is running all SQL instance.
Are you using a named instance?
Also see if there are an resource jobs are running.

share|improve this answer

answered May 12 '11 at 14:33

Satya SKJSatya SKJ

393

share|improve this answer

answered May 12 '11 at 14:33

Satya SKJSatya SKJ

393

answered May 12 '11 at 14:33

Satya SKJSatya SKJ

393

answered May 12 '11 at 14:33

Satya SKJSatya SKJ

393

0

The distributor is what is recording the changes from the publisher and queueing them before they are sent to the subscriber.

The default is to do a push subscription where no connectivity is needed from the subscriber to the distributor as the connection goes from the distributor to the subscriber. That being the case I'm guessing that there's a firewall blocking either UDP port 1434 on the publisher, or there's a firewall blocking the TCP port that the named instance on PRIMARYSERVER is listening on.

share|improve this answer

answered Mar 4 '13 at 20:58

mrdennymrdenny

26.4k43466

add a comment | 

0

The distributor is what is recording the changes from the publisher and queueing them before they are sent to the subscriber.

The default is to do a push subscription where no connectivity is needed from the subscriber to the distributor as the connection goes from the distributor to the subscriber. That being the case I'm guessing that there's a firewall blocking either UDP port 1434 on the publisher, or there's a firewall blocking the TCP port that the named instance on PRIMARYSERVER is listening on.

share|improve this answer

answered Mar 4 '13 at 20:58

mrdennymrdenny

26.4k43466

add a comment | 

The distributor is what is recording the changes from the publisher and queueing them before they are sent to the subscriber.

The default is to do a push subscription where no connectivity is needed from the subscriber to the distributor as the connection goes from the distributor to the subscriber. That being the case I'm guessing that there's a firewall blocking either UDP port 1434 on the publisher, or there's a firewall blocking the TCP port that the named instance on PRIMARYSERVER is listening on.

share|improve this answer

answered Mar 4 '13 at 20:58

mrdennymrdenny

26.4k43466

share|improve this answer

answered Mar 4 '13 at 20:58

mrdennymrdenny

26.4k43466

answered Mar 4 '13 at 20:58

mrdennymrdenny

26.4k43466

answered Mar 4 '13 at 20:58

mrdennymrdenny

26.4k43466