Replication over VPN

I think that the configuration for replication via VPN is the same as that
used on a LAN. But I can not register remote SQLserver by name and it does
not work by IP.
1. Does it work in case dynamic IP ?
2. Use alias name instead of IP address ?
3. Other recomendations .
Please help.
Thank you.
a vpn should be the same as a local lan. It will work by dynamic ip if it
can resolve the subscriber by host name. However, it sounds like you can't
do this. You need to work on the name resolution issue. It could be a
network connection problem. Tracert should help you to figure out where the
break is.
Hilary Cotter
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
"Thang Long" <Thang Long@.discussions.microsoft.com> wrote in message
news:0F60A7B1-DF73-41F3-AF6F-9D3B64A3780E@.microsoft.com...
> I think that the configuration for replication via VPN is the same as that
> used on a LAN. But I can not register remote SQLserver by name and it does
> not work by IP.
> 1. Does it work in case dynamic IP ?
> 2. Use alias name instead of IP address ?
> 3. Other recomendations .
> Please help.
> Thank you.
>
>
|||Thank you for your reply.
The remote server named SERVER. Does it break naming rules ?
Many thanks.
Thang Long
"Hilary Cotter" wrote:

> a vpn should be the same as a local lan. It will work by dynamic ip if it
> can resolve the subscriber by host name. However, it sounds like you can't
> do this. You need to work on the name resolution issue. It could be a
> network connection problem. Tracert should help you to figure out where the
> break is.
> --
> Hilary Cotter
> 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
> "Thang Long" <Thang Long@.discussions.microsoft.com> wrote in message
> news:0F60A7B1-DF73-41F3-AF6F-9D3B64A3780E@.microsoft.com...
>
>
|||it might, I would try a fully qualified domain name in the alias section.
Also make sure there are no entries for it in
%windir%\system32\drivers\etc\hosts
Hilary Cotter
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
"Thang Long" <ThangLong@.discussions.microsoft.com> wrote in message
news:61B0C5A5-B8AD-4003-A1E4-4EF2B64FA6C9@.microsoft.com...[vbcol=seagreen]
> Thank you for your reply.
> The remote server named SERVER. Does it break naming rules ?
> Many thanks.
> Thang Long
> "Hilary Cotter" wrote:
it[vbcol=seagreen]
can't[vbcol=seagreen]
the[vbcol=seagreen]
that[vbcol=seagreen]
does[vbcol=seagreen]
|||Doesn't break rules, try to the following.
ping SERVER
If you see the IP address in the lines follwoing this request and it's the
correct IP the DNS is funcitoning properly.
If the IP address is wrong or no IP address is given you may need the
assistance of the network administrator. I've seen it where a new remote
client VPN tunnel had an access-list misconfigured that then wouldn't let it
pull DHCP/DNS information accross the tunnel.
HTH,
GTM
"Thang Long" <ThangLong@.discussions.microsoft.com> wrote in message
news:61B0C5A5-B8AD-4003-A1E4-4EF2B64FA6C9@.microsoft.com...[vbcol=seagreen]
> Thank you for your reply.
> The remote server named SERVER. Does it break naming rules ?
> Many thanks.
> Thang Long
> "Hilary Cotter" wrote:
|||Where could I find step-by-step guide to setup sql replication between
non-trusted domains.
Thank you.
"Hilary Cotter" wrote:

> it might, I would try a fully qualified domain name in the alias section.
> Also make sure there are no entries for it in
> %windir%\system32\drivers\etc\hosts
> --
> Hilary Cotter
> 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
> "Thang Long" <ThangLong@.discussions.microsoft.com> wrote in message
> news:61B0C5A5-B8AD-4003-A1E4-4EF2B64FA6C9@.microsoft.com...
> it
> can't
> the
> that
> does
>
>
|||Paul, thank you. I try replication using VPN, but your article outlines what
to if a VPN is not available. Please tell me other articles.
Rgds,
"Paul Ibison" wrote:

> Thang,
> please take a look at this article:
> http://www.replicationanswers.com/InternetArticle.asp
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
|||If can not resolve the subscriber by host name. Could I use client network
utility to create alias name and cofigure replication ?
Thank you.
"Greg" wrote:

> Doesn't break rules, try to the following.
> ping SERVER
> If you see the IP address in the lines follwoing this request and it's the
> correct IP the DNS is funcitoning properly.
> If the IP address is wrong or no IP address is given you may need the
> assistance of the network administrator. I've seen it where a new remote
> client VPN tunnel had an access-list misconfigured that then wouldn't let it
> pull DHCP/DNS information accross the tunnel.
> HTH,
> GTM
>
> "Thang Long" <ThangLong@.discussions.microsoft.com> wrote in message
> news:61B0C5A5-B8AD-4003-A1E4-4EF2B64FA6C9@.microsoft.com...
>
>
|||Thang,
sorry - your question related to 'non-trusted domains' so I supposed you
were trying an alternative to the VPN setup. I don't know of any specialized
VPN articles.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Yes, use client network utility to create alias name and specify
alternate snapshot folder using IP adress.
This worked for me,
Adrian