Groups | Blog | Home
all groups > sql server clustering > november 2004 >

sql server clustering : Node Cluster - Fails on Network Resources


Debbie
11/30/2004 10:21:05 AM
I am running a 2-node cluster for SQL Server. After powering down both
servers (passive then active), one of the nodes did not successfully join the
cluster. This node shows exclamation marks on the Network Interfaces in
Cluster Administrator. These nics are functioning correctly outside of the
cluster. The cluster log on the failed node indicates that these network
interfaces are functioning each time it tries to join the cluster. The
active node's cluster log indicates that these resources are not functioning
and removes the other node from being active.

If anyone has any ideas on how to solve this problem, your input would be
greatly appreciated.
Thanks,
Debbie
Ayad
12/2/2004 9:18:28 AM
Is the NIC you have exclamation mark on Public or Private network?

Ayad

[quoted text, click to view]

Debbie
12/3/2004 8:33:10 AM
There are three NICs, the heartbeat (crossover), private (for backups) and
our intranet. All three have the exclamation mark.

[quoted text, click to view]
Debbie
12/3/2004 10:09:03 AM
Ayad,

This is not a new install. It was working before. We had to power down all
of the servers for a generator hook-up to be installed. When bringing the
cluster back up, this server failed and has failed ever since with these NIC
resource errors.

The subnets look good on the NICs.

Thanks,
Debbie

[quoted text, click to view]
Ayad
12/3/2004 12:54:12 PM
Check your IP settings and make sure you are using the correct subnet mask
address and network segment for each port and match each port with the other
node's port.

Was it working before or this is a new install?

Ayad

[quoted text, click to view]

Ayad
12/4/2004 1:10:23 PM
Debbie,

Try Shutdown that node (server hard reboot) and power it ON again and see if
it clears your NIC issue.

Ayad

[quoted text, click to view]

Debbie
12/10/2004 1:59:03 PM
Ayad,

The hard reboot did not clear up the problem. I am thinking of removing
this node from the cluster and then readding it to the cluster to see if that
clears up the problem.

Thanks,
Debbie

[quoted text, click to view]
AddThis Social Bookmark Button