all groups > sql server replication > september 2007 >
You're in the

sql server replication

group:

Merge Replication and Named Pipes Protocol


Re: Merge Replication and Named Pipes Protocol Hilary Cotter
9/5/2007 12:00:00 AM
sql server replication:
Yes, however is one of the machines part of a work group? You might be
running into a connection limit issue.

--
RelevantNoise.com - dedicated to mining blogs for business intelligence.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
[quoted text, click to view]

Merge Replication and Named Pipes Protocol J Jones
9/5/2007 7:34:02 AM
I'm trying to setup merge replication and am running into the following error
during syncronization to the subscriber:

Named Pipes Provider: Could not open a connection to SQL Server [53].

On the publisher, I can register the subscriber via tcp/ip without issue,
but the Replication-specific connection appears (from the error above) to
default to Named Pipes. Can I override this default named pipes behavior and
just use TCP/IP?
Thanks!
Jeff Jones
Re: Merge Replication and Named Pipes Protocol J Jones
9/5/2007 8:02:03 AM
Thanks Hilary - no, both machines are joined to a domain, albeit different
ones. I can connect to the subscriber via named pipes from my local machine,
but not from the publisher. I'm sure there's a firewall rule preventing the
NP connection, but I'd prefer to use IP anyway. How do I tell replication to
use IP instead of NP?
Jeff

[quoted text, click to view]
Re: Merge Replication and Named Pipes Protocol Hilary Cotter
9/8/2007 6:33:34 AM
Can you set up an alias using tcp/ip. Deregister the subscriber in EM/SSMS
and then re-add it?

--
RelevantNoise.com - dedicated to mining blogs for business intelligence.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
[quoted text, click to view]

AddThis Social Bookmark Button