Hello All,

I need to move a SQL Server Cluster from one subnet to another subnet so I
need to update 5 cluster IP addresses (node a, node b, cluster, SQL Server
and MS DTC). Any help on how to do this would be appreciated.

I found article 230356 explaining how to change the IP address in the nodes
but it is still confusing because it says that "do not work ... if you change
the IP address from one subnet to abother subnet". Then Allan Hirts' book
'SQL High Availability' shows the same procedure (page 190) but says
'Warning: Do not do this unless your servers need to change subnets". Any
idea what the problem is here?

Looks like article 244980 describes how to change the IP address for SQL
Server.

I still need to know how to change the IP address for the cluster and for
MSDTC.

Any help on this?

Thanks,

Benjamin Nevarez
SQL Server Database Administrator

The article can be very confusing. The key to remember is that your cluster
always needs a clear communications path for its private communications.
Everything else is optional. Of course, you may be offline for a while
during the transition. Here are a few absolutely key elements

Make sure you have the 'Public" interface enabled for private
communications. Then you can change the private network without losing the
cluster. Once the private side is stable, you can change the public side.

Don't forget the impact of changes on your SAN. It may not like having a
host change IP addresses.

Make sure to read this KB article as well.

How to change the network IP addresses of SQL Server virtual servers
http://support.microsoft.com/kb/244980/

Geoff N. Hiten
Microsoft SQL Server MVP.


"Benjamin Nevarez" <BenjaminNevarez (AT) discussions (DOT) microsoft.com> wrote in
message news:782BC7F5-3D71-4543-860B-92F396F9115F (AT) microsoft (DOT) com...