How to setup replicaton over WAN (using DNS hostname and IP addres

Has another successfully setup SQL 2005 replication over WAN without the need
for name pipes nor UNC server name? i.e. using only DNS hostname and IP
address for the source and target SQL 2005 servers?
If so, can you share how you did it, and what are the firewall ports to
open? I need to be able to at least do a one-to-many publication (one
direction) replication.
Please advise.
Thank you.
Hello,
You could consider using "web sync" for this issue. It just needs https 443
port and IIS to be published to the Internet.
http://msdn2.microsoft.com/en-us/library(d=robot)/ms147927.aspx
Also, you could setup VPN connection between publisher/subscriber or
between LANs on different sites. You could then setup replicaiton just as
that they are in the same LAN.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Thread-Topic: How to setup replicaton over WAN (using DNS hostname and IP
addres
>thread-index: AcYypJSK0As+BG/bQyuvGhjq324yHg==
>X-WBNR-Posting-Host: 216.254.123.226
>From: "=?Utf-8?B?YnNhbmRlcnM=?=" <missisummer@.community.nospam>
>Subject: How to setup replicaton over WAN (using DNS hostname and IP addres
>Date: Wed, 15 Feb 2006 18:56:27 -0800
>Lines: 11
>Message-ID: <858F748C-1703-41B8-ABD8-034615434D67@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
>charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.replication
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.replication:69369
>X-Tomcat-NG: microsoft.public.sqlserver.replication
>Has another successfully setup SQL 2005 replication over WAN without the
need
>for name pipes nor UNC server name? i.e. using only DNS hostname and IP
>address for the source and target SQL 2005 servers?
>If so, can you share how you did it, and what are the firewall ports to
>open? I need to be able to at least do a one-to-many publication (one
>direction) replication.
>Please advise.
>Thank you.
>