How to Sync over a WAN
Posted on 2008-10-06
I have a SQL server as part of my local domain and wish to have another server (standalone server) in a remote location with syncronisation, between the sql server and standalone server.
I thought i'd be able to insert an additional network card in the sql server and use this for vpn'ing onto the standalone server running RRAS. The problem is when the card is active, it gets assigned an IP from DHCP of the LAN and then my local users are complaining they cant access the sql software.
Is there a better way around this?