Solved

How to Sync over a WAN

Posted on 2008-10-06
5
413 Views
Last Modified: 2012-05-05
Hi

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?

Thanks
0
Comment
Question by:teknite
  • 3
  • 2
5 Comments
 
LVL 3

Expert Comment

by:tismetoo
ID: 22649768
A couple of options:

Allocate a static IP address to the network card, but you will need to take off the "register this connections address in DNS" to avoid the same issue with the clients. You can do this on a DHCP allocation, but the DHCP server ( depending on what is allocating the addresses ) may register the IP address in DNS regardless.

Use another connection mechanism such as IPSec VPN, which would allow the server to communicate on the original IP address. But I guess you don't have the hardware otherwise you wouldn't be using RRAS.
0
 

Author Comment

by:teknite
ID: 22649838
Thanks. Our SBS box is DHCP'ing to the network, which is our DC.
Should we allocate the address as part of the LAN range or an IP address as part of the remote site?
0
 
LVL 3

Expert Comment

by:tismetoo
ID: 22650149
I presume you only have a single subnet at the SQL server site - in which case it should be a local IP address. You then have to sort out how the 2 sites connect - unless you can do that already.

Once that is done you will be advised to add a route to the remote site to send the traffic out of the static IP interface, which will ensure the comms are going out of the correct interface locally.

Incidentally, why do you need a second network card - that is not clear at the moment? If IP routing is working correctly you should not need it, unless you want to seperate the traffic for performance or secruity reasons.
0
 

Author Comment

by:teknite
ID: 22707439
Yes thats right we have a single subnet. my thoughts were to have the sql server vpn'ing to the 2nd site with RRAS being run on the member server.
My thoughts of a 2nd card were to route traffic through that card and keep it seperate form the network.

Are these good practices or should i be doing something else? All i know is that the sync sofware can only sync via vpn over the WAN.
0
 
LVL 3

Accepted Solution

by:
tismetoo earned 500 total points
ID: 22716009
If you can isolate the traffic from your primary LAN on a second card, with VLANs or a seperate port on your firewall, then it would be a good way of isolating the traffic. If you can't isolate the traffic in that way then I suspect you are going to cause yourself more headaches than you need - with routing and firewall configuration for a seperate subnet on the same physical LAN segment.

The other way of looking at this is if RRAS is installed on the remote server, it will only be able to talk to your SQL server anyway, assuming your firewall is managing sessions correctly with NAT. Whether it does this from the same IP address or from a different IP address will probably not make much difference. I would be inclined to stick with the single interface card, unless you can isolate the traffic with VLAN or a seperate zone on your firewall.
0

Featured Post

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

Numerous times I have been asked this questions that what is it that makes my machine log on so slow, there have been cases where computers took 23 minute exactly after taking password and getting to the desktop. Interesting thing was the fact th…
I've always wanted to allow a user to have a printer no matter where they login. The steps below will show you how to achieve just that. In this Article I'll show how to deploy printers automatically with group policy and then using security fil…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now