Solved

2 LAN/WAN on One Server

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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

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).
PRTG Network Monitor lets you monitor your bandwidth usage, so you know who is using up your bandwidth, and what they're using it for.
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…
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…

707 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