Solved

2 LAN/WAN on One Server

Posted on 2016-09-23
2
62 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

Connect further...control easier

With the ATEN CE624, you can now enjoy a high-quality visual experience powered by HDBaseT technology and the convenience of a single Cat6 cable to transmit uncompressed video with zero latency and multi-streaming for dual-view applications where remote access is required.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
HP network exams 3 56
Layer 3 switch recommendation 15 49
Certifications 8 36
SSL-VPN 1 43
Even if you have implemented a Mobile Device Management solution company wide, it is a good idea to make sure you are taking into account all of the major risks to your electronic protected health information (ePHI).
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…

685 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