I have a SQL 2000 2-node cluster that is working fine. In a few days they
will be changing the networking on the network where this cluster is located.
I will need to change the subnet mask from 255.255.255.0 to 255.255.254.0.
I don't need to change the IP address of the cluster or the nodes - just the
subnet mask.

My question is should I change this subnet mask on each individual node in
the Network Control Panel - and then go change the Windows cluster and SQL
cluster in the Cluster Administrator utility?

This can be done, but it is a bit tricky. The important thing is to make
sure the cluster always has a communication path. Make sure cluster
communications goes through the private and the public network. Change the
private and make sure it is working. Then change the public.

Here is how to change the network for the cluster itself:

Changing the IP address of network adapters in cluster server
http://support.microsoft.com/kb/230356/

This will break SQL so you then have to do this:
How to change the network IP addresses of SQL Server failover cluster
instances
http://support.microsoft.com/kb/244980/en-us

I have used these procedures and they do work. Again, always make sure the
cluster has a way to communicate and you will be fine.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP




"Amy Lewis" <AmyLewis (AT) discussions (DOT) microsoft.com> wrote