Solved

2 LAN/WAN on One Server

Posted on 2016-09-23
2
57 Views
Last Modified: 2016-11-06
Hi,
On the primary network, the sqlserver is being replicated to another server, while it's easy to configure the primary and secondary server.
How do you configure the secondary to communicate with the primary server on a class C network to receive updates from sqlserver and communicate with the WAN at the same time?

Primary GW: 10.1.1.1
Secondary GW: 192.168.1.1
0
Comment
Question by:S Khan
2 Comments
 
LVL 14

Accepted Solution

by:
Schnell Solutions earned 500 total points
ID: 41812690
You go to the network interfaces window and configure for yout servers the NIC corresponding to the SQL communication with the top priority (you can change the order pressing the alt key and opening the advance configuration from the menu).

Additionally, remove the default gateway on the nic that does not connect to the internet (provably the intercommunication noc). If required, add manual routes for reaching any network that you were reaching through the default gateway.
0
 

Author Comment

by:S Khan
ID: 41876362
Hi Guys,
Currently, I have one server room, we are going to install a second server room at the back of a large building. The main reason for this is, in the event of a fire, we will have a copy of the sql server so we can resume business. all the office pc (2 dozen) will be physically uplugged from the primary network into secondary network.

Since the two database servers will be connected via fiber optics approx 300 feet away, should 1 use a failover DHCP or a seperate DHCP?

You're help is greatly appreciated.
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Don’t let your business fall victim to the coming apocalypse – use our Survival Guide for the Fax Apocalypse to identify the risks and signs of zombie fax activities at your business.
In this article, I am going to show you how to simulate a multi-site Lab environment on a single Hyper-V host. I use this method successfully in my own lab to simulate three fully routed global AD Sites on a Windows 10 Hyper-V host.
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

896 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

13 Experts available now in Live!

Get 1:1 Help Now