Has anyone configured two servers in the following situation?
Server A will be running a web based application.
Server B will be running SQL server.
The application is designed to connect with remote SQL server databases, so I know this part already works correctly. The networking part I’m not so sure about.
I made a recommendation today for the two servers to utilize one their gigabit Ethernet connections. Both servers have built-in dual gigabit Ethernet adapters. Our main network is only 10/100 (which won’t change), so I mentioned using the second NIC on both hosts as a direct cable connection to utilize the speed of 1000Mb. This connection would be used for Server A to access SQL server on Server B.
I envisioned server A having a public and private network address. Public connection is connected on our house network for all access and the Private is for the direct connection to Server B. The same scenario applies to server B. Does this sound like a terrible setup? All users will access server A, which has the production application. Server B will be accessed for other general work so it also needs a public connection. Both servers will be running windows 2000 Advanced Server.
Does that sound like a useful setup, or is it better to disable the second NIC on both host and stick with the 10/100 network? My worry is that SQL server cannot “listen” (multihomed?) on two network adapters. If someone needs to use SQL server on Server B from the public network, I don't know if this is possible.
Server A will be running a web based application.
Server B will be running SQL server.
The application is designed to connect with remote SQL server databases, so I know this part already works correctly. The networking part I’m not so sure about.
I made a recommendation today for the two servers to utilize one their gigabit Ethernet connections. Both servers have built-in dual gigabit Ethernet adapters. Our main network is only 10/100 (which won’t change), so I mentioned using the second NIC on both hosts as a direct cable connection to utilize the speed of 1000Mb. This connection would be used for Server A to access SQL server on Server B.
I envisioned server A having a public and private network address. Public connection is connected on our house network for all access and the Private is for the direct connection to Server B. The same scenario applies to server B. Does this sound like a terrible setup? All users will access server A, which has the production application. Server B will be accessed for other general work so it also needs a public connection. Both servers will be running windows 2000 Advanced Server.
Does that sound like a useful setup, or is it better to disable the second NIC on both host and stick with the 10/100 network? My worry is that SQL server cannot “listen” (multihomed?) on two network adapters. If someone needs to use SQL server on Server B from the public network, I don't know if this is possible.
