Hello group, I need to set up replication between 2 sites today. I have
successfully implemented transactional and snapshot replication within
the same office servers before.

I need help configuring 2 servers that are in 2 different cities and not
on the same network.
First of all, is this possible? I can connect to the servers by IP in
Enterprise Manager, but when it comes to performing replication, I think
I am running into problems with the publication folder that one server
needs to access from another.

Is my only option to set up a VPN, or can I do this through the internet
like I am now and use SSL later to secure.

Help appreciated.
Steve



*** Sent via Developersdex http://www.developersdex.com ***

Steve,
both VPN and internet replication are possible. Have a
look at this article for more info:
http://support.microsoft.com/?id=321822
If you don't use a VPN then you'll need to do FTP
initialization and use SQL Server security.
HTH,
Paul Ibison

(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Paul, this is perfect. Thanks for your help and the info. The only thing
that concerns me now is that I was up on Microsoft a few times and never
ran across this document.

I guess I need to practice my search skills too!!

Thanks,
Steve

*** Sent via Developersdex http://www.developersdex.com ***