Solved

2 LAN/WAN on One Server

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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Port forwarding 14 149
adding a printer to QAD 10 62
Filter IP range with PowerShell 1 40
DNS issue with resolving request 14 84
#Citrix #Citrix Netscaler #HTTP Compression #Load Balance
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
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…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

813 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

10 Experts available now in Live!

Get 1:1 Help Now