dbTalk Databases Forums  

Dual Nics problems with SQL 2000 Cluster

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss Dual Nics problems with SQL 2000 Cluster in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
caicia
 
Posts: n/a

Default Dual Nics problems with SQL 2000 Cluster - 04-04-2004 , 08:26 AM






HI
I have two Dell Servers(For high avaiablity each machines have three intel gigabit Networkcards,one for heatbeat,two for clients link) with a disk array.I have installed Windows2003 and setup the Cluster,it's worked well,then i installed sql server 2000 EE on them through many articles(I created tow sql ip address because i have two nics on each servers).When one node fail,the resource can shift to another node,the sql service is still available.Ok,but when one switch of the two seperate network is down,the sql service is nolonger avaliable,there is no use for another network cards on each node? Is there any articles for sql server's installation for nodes with three nics
Another problem is that it take about 3 min for sql resource such as sql ip address,sql network name,sql server etc to transmit from one node to another,obviously it's too long,but i can't solve it
I hope I 1can describe the phenomenas and i need your help,thank you!

Reply With Quote
  #2  
Old   
Stephen Strong
 
Posts: n/a

Default RE: Dual Nics problems with SQL 2000 Cluster - 04-04-2004 , 05:41 PM






You could use NIC Teaming on the 2 common NICs. The two teamed NICs combine to present a third "NIC" to the o/s with a common IP Address. SQL Server sees this common IP and doesn't complain when either of the physical NICs or switches fails. As your NIC vendor if they support teaming (you'll need some Teaming software).

Reply With Quote
  #3  
Old   
caicia
 
Posts: n/a

Default RE: Dual Nics problems with SQL 2000 Cluster - 04-04-2004 , 07:26 PM



If I set two networks,one is 172.20.1.*and the other is 172.20.2.*,then which network should I config for the third "NIC" for all clients(they all have two NICs) to link?

Reply With Quote
  #4  
Old   
Stephen Strong
 
Posts: n/a

Default RE: Dual Nics problems with SQL 2000 Cluster - 04-07-2004 , 09:11 PM



When 2 NICs are teamed, only one is in use at any one time. You don't set the IP Address of each NIC you set the single IP address of the resulting teamed "NIC". So, you could have say NIC1 and NIC2 as your physical NICs. Then team them and call the result "Public Network Connection" (or something more useful) which would have the IP address "172....". When you set up clustering, the public network will be "Public Network Connection" rather than NIC1 or NIC2. Make sure you set "Public Network Connection" as the highest priority in the network advanced=>advanced settings list.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.