Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Need to add additional NIC to SQL cluster - to enable team..

 
   Database Help (Home) -> Clustering RSS
Next:  Semistructured data  
Author Message
user2172

External


Since: Dec 17, 2004
Posts: 2



(Msg. 1) Posted: Mon Feb 21, 2005 8:40 am
Post subject: Need to add additional NIC to SQL cluster - to enable teamin
Archived from groups: microsoft>public>sqlserver>clustering (more info?)

Hi

I have 2 questions, but related!

We currently have a Windows 2000 Adv server running SQL Ent 2000 as a 2 node
cluster.

Each node currently has 2 NICs installed, one NIC for the local heartbeat
and the other for the LAN connection.

We now need to add another NIC to each cluster node for failover resillience
on the LAN connection.

The idea is to add the extra NIC, so that we can implement teaming on 2
NICs.

1.What needs to be done to the cluster in order to achieve this and ensure
that the cluster still functions as per normal.

2. The installed NIC has 2 ports, so i assume that additional NIC purchased
may be different, my guess is that teaming different type NIC cards is not a
good idea, therefore i would like to reconfigure for the teaming to be on
the NIC with the 2 ports and the heartbeat on the newly purchased NIC. - Is
this a big job- what needs to be carried out in order to achive this!!!

Cheers Ray

 >> Stay informed about: Need to add additional NIC to SQL cluster - to enable team.. 
Back to top
Login to vote
Rodney R. Fournier1

External


Since: Apr 20, 2004
Posts: 37



(Msg. 2) Posted: Tue Feb 22, 2005 1:47 pm
Post subject: Re: Need to add additional NIC to SQL cluster - to enable te [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Answers below...

Cheers,

Rod

MVP - Windows Server - Clustering
<a rel="nofollow" style='text-decoration: none;' href="http://www.nw-america.com" target="_blank">http://www.nw-america.com</a> - Clustering
<a rel="nofollow" style='text-decoration: none;' href="http://msmvps.com/clustering" target="_blank">http://msmvps.com/clustering</a> - Blog

<Ray> wrote in message
 > Hi
 >
 > I have 2 questions, but related!
 >
 > We currently have a Windows 2000 Adv server running SQL Ent 2000 as a 2
 > node
 > cluster.
 >
 > Each node currently has 2 NICs installed, one NIC for the local heartbeat
 > and the other for the LAN connection.
 >
 > We now need to add another NIC to each cluster node for failover
 > resillience
 > on the LAN connection.
 >
 > The idea is to add the extra NIC, so that we can implement teaming on 2
 > NICs.
 >
 > 1.What needs to be done to the cluster in order to achieve this and ensure
 > that the cluster still functions as per normal.

A properly configured TEAM is not seen by the cluster. In other words, its
seamless. It just works like a single NIC and the Cluster is never the wiser
Smile Cool huh?

 >
 > 2. The installed NIC has 2 ports, so i assume that additional NIC
 > purchased
 > may be different, my guess is that teaming different type NIC cards is not
 > a
 > good idea, therefore i would like to reconfigure for the teaming to be on
 > the NIC with the 2 ports and the heartbeat on the newly purchased NIC. -
 > Is
 > this a big job- what needs to be carried out in order to achive this!!!
 >

Take everything offline - cluster services and all resources. Change the
IP's on the NIC - on each node. Do a few ping tests to verify things are
working. Start the cluster service and use "." to start the Cluster
Administrator.

Use these for information:
<a rel="nofollow" style='text-decoration: none;' href="http://support.microsoft.com/default.aspx?scid=kb;en-us;244980" target="_blank">http://support.microsoft.com/default.aspx?scid=kb;en-us;244980</a>
<a rel="nofollow" style='text-decoration: none;' href="http://support.microsoft.com/default.aspx?scid=kb;en-us;230356" target="_blank">http://support.microsoft.com/default.aspx?scid=kb;en-us;230356</a>

Good luck, its really not that bad.


 > Cheers Ray

 >> Stay informed about: Need to add additional NIC to SQL cluster - to enable team.. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Need to add additional NIC to SQL Cluster - Hi We recently built a W2K Advanced server, SQL Ent 2000 cluster. Each node of the cluster had 2 NIC ports: 1 NIC was used for Cross over cable Other NIC was used for LAN. All standard build servers in our environment should have 2 NIC connections -....

CLUSTER NAME - Hi , is there any command to display current cluster name through query . Thanks ARR

Using SQL Mail in a cluster - Hello, I'm trying to set up alerts for jobs and backups, using sql mail. Will this work in a clustered enviroment? if so, can you please forward some information on how to get this set up? thanks in advace. Calvin

2000 Cluster - We're going to have to move data to a new 2000 SP4 server. We want to cluster it down the road, probably Q4 of 2008, but can't do it right now. So here's my question: 1. What do I have to do to this new server to make sure it can be clustered abou...

Cluster Issue - Hello, I have a Wndows 2003 Sql 2005 Cluster consisting of two servers, on Failover from node2 to node1 the application user is unable to login until the sql server is restarted, on failover all the resourses come online but the user is unable to..
   Database Help (Home) -> Clustering All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]