Avatar of Robert Pilcicki
Robert Pilcicki
 asked on

Running 2 servers on same network

My company has two physical locations each with its own server running AD DS, DNS, DHCP and their own unique databases.   All workstations in both locations run identical applications.    Location A will be shutting down for a couple of months for renovations.   I would like to move server A  to location B so its database can be accessed.   I was planning on giving server A a DHCP scope of 10-130, while configuring server B a scope of 130-250 all under the same 192.168.1.xxx.    Server A (Windows Server 2008 R2) would have an address of while server B (Windows Server 2016 Standard) would be

Would the 20 workstations at location B be able to switch back and forth between Domain A and Domain B simple by logging out of A and into B?

If this theory is not correct, what is the proper way of setting this up?
DatabasesDHCPDNSWindows 10Azure

Avatar of undefined
Last Comment

8/22/2022 - Mon
David Johnson, CD

not really since a machine is joined to a domain. The user doesn't need to logout of current domain to access the other domain's data you just have to be given share permissions. i.e. you would share domainA's data using a user account xxxx@domainA
Robert Pilcicki

Thank you for the quick reply David.   Here are more specifics that may cause a problem with your suggested solution:   These are dental offices that use the same (but unique) practice management and dental imaging databases.    Location A points to a database on server A.    Obviously location B points to a database on server B.   During the reconstruction period, if a patient from location A comes to location B, I want the staff to be able to switch to database A.    If the patient is from location B, I want the staff to switch to database B.    If they are simply shared, the practice management software won't know where (database A or database B) to access and/or store the data.  

My hope was to have 2 different user profiles:   DomainA points to the database on ServerA and DomainB points to the database on ServerB.   Since I have never done this before I am concerned that I may be inviting conflicts that could be avoided.

If it was not setup in the begining depending on the SQL version, and whether the locations were tied in ... Using merge replication, or other mechanism that dealt with consolidating data from the various locations into the "central"

A dynamic db selection based on the customer would also require the setup to exist prior.

Your scenario would require an employee to use the correct system that has access to the db that reflects info for the pt.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Robert Pilcicki

Thank you Arnold for your reply.   I do not want/need to merge or consolidate the data in any way because after the renovations are complete, server A will be going back to its original location.     A & B databases need to be completely independent of each other before, during and after the renovations.

Are the application users access at each location, are these web based applications and did you create them?

If it is a web based, and can have each user to have two tabs one to each application that queries their respective db.

In the constraint you have, only way is to have a front end that interacts with each application and then depending on the application from which it gets a response that the user exists  to then proxy requests ...

Presumably if a new person comes in you may still would want to find out if this or the other location will be their primary/preferred...

Often medical softwares include handling of multiple locations which might be a path to explore for future expansion...
Sarang Tinguria

So you have 2 Dental clinics and one of them is going under renovation so the infrastructure from Clinic1 will be temporarily moved to Clinic2

So are you not moving the users and their workstations from clinic1 to Clinic2 ?

It all seems application and Database related handling...have you tried involving the vendor .... if you have layer 3 switch then you can just create two seperate VLAN and run two different network in same location
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Robert Pilcicki

Thank you everyone for your input.   As it turns out the owners have opted against having the two servers in the same location and instead have chosen to use remote connections between LocationA and LocationB.   Eventually I might try temporarily relocating the other server just to test out some of these recommendations

View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.