| Author |
Topic |
|
2112
Starting Member
2 Posts |
 Posted - 2009-06-24 : 10:44:13
|
Sorry if this sounds newbish or has been covered before.Two SQL servers currently sit on their own networks. Each server's network has its own clients. Three clients need access to both servers and use two NIC's to do this. This has worked fine for the last three years.Can we merge these two networks, thereby placing both servers on the same network? The servers do not need to talk to each other, and there will be no queries or reports that will be made simultaneously to both servers. They will operate the same as they do now: mutually exclusive with their own clients and some clients will need access to both.Is this possible? What do I need watch out for? Any suggs on setup?Thanks!  |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2009-06-24 : 14:06:39
|
| Should be no problem. An instance of SQL Server does not require anything (networking-wise) beyond a port on the local box. |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-06-24 : 23:14:12
|
quote:
Three clients need access to both servers and use two NIC's to do this
Depending on your network configuration and routing, you might not need two NIC. You can have multiple IP addresses assign to the same NIC.
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
2112
Starting Member
2 Posts |
Posted - 2009-06-26 : 12:08:05
|
quote:
Originally posted by khtan
quote:
Three clients need access to both servers and use two NIC's to do this
Depending on your network configuration and routing, you might not need two NIC. You can have multiple IP addresses assign to the same NIC.
KH[spoiler]Time is always against us[/spoiler]
Thank you for the replies, all. :-)I tried assigning multiple IP's to the same NIC thru TCP/IP settings, but I could not get a connection to either network when I had it configured this way.The configuration was just your basic advanced tab deal. Should I be looking out for any specific traps or should I do anything special to increase the chance that the two-ip-one-NIC configuration will work?Thanks again! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-06-26 : 19:40:03
|
it really depends on your network configuration. Are the 2 subnet just a virtual network, physicall it is connected to the same switchs / hubs, or they are routers / firewall in-between ?
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-06-26 : 19:58:14
|
actually what's the based problem here ? You have client in one subnet cannot access to the Server on the other subnet ?
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
|
Two SQL servers on one subnet?