Dual NICs

Question

Post reply

Dual NICs

John Kandrovy

Right there with Babe

Points: 751
More actions
October 2, 2007 at 9:47 am

#178452

Question? we are looking to build a brand new server for a sql 2000 and then possible migrate to 2008 whenever it comes out... all the hardware configurations we are seeing are saying that we should get two NIC's and use both. Any ideas of how we would do that?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

it's handled automatically by the operating system;

you might have one nic that has an internal IP for your network, lets say 192.168.1.50

the other NIC might have an IP address on a completely different network so that the web server can talk to it, say 10.2.0.50; very typical in a DMZ so that the web server/sql server exposure is minimized.

the server will answer calls to SQL Server automatically, unless a firewall prevents traffic, so I can build a connection string for internal use like

ConnectionString="Provider=SQLOLEDB.1;Password=welcome;Persist Security Info=False;User ID=tester;Initial Catalog=GHBA;Data Source=192.168.1.50"

as well as from the web server

ConnectionString="Provider=SQLOLEDB.1;Password=welcome;Persist Security Info=False;User ID=tester;Initial Catalog=GHBA;Data Source=10.2.0.50"

if the WIN or DNS has an entry for the servername, you might be able to replace the IP with the SERVERNAME, or maybe server.yourdomain.com; in the end, all names are replaced with an ip address behind the scenes.

from the SQL side, it's transparent.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

DiverKas SSCrazy Points: 2049 More actions · Answer 2

John Kandrovy (10/2/2007)
Question? we are looking to build a brand new server for a sql 2000 and then possible migrate to 2008 whenever it comes out... all the hardware configurations we are seeing are saying that we should get two NIC's and use both. Any ideas of how we would do that?

More than likely, the NICs will be teamed. For example, on the HP's/Compaq servers, the software comes with the server to make the 1GB ethernet cards form 1 pipe, basically 1 card handles all inbound traffic and all outbound is split between them. Effectively giving you a 2GB pipe outbound. This works well for databases and webservers because in general you pipe out more traffic than what is inbound.