[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

2 LAN/WAN on One Server

Posted on 2016-09-23
2
Medium Priority
?
78 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 14

Accepted Solution

by:
Schnell Solutions earned 2000 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

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

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

When it comes to security, there are always trade-offs between security and convenience/ease of administration. This article examines some of the main pros and cons of using key authentication vs password authentication for hosting an SFTP server.
This article explains the fundamentals of industrial networking which ultimately is the backbone network which is providing communications for process devices like robots and other not so interesting stuff.
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…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

656 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