Moving SQL Cluster to a new subnet

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


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

.

Relevant Pages

  • Re: Changing IP address for 2 Nodes, Cluster IP and SQL IP
    ... If you change the subnet mask for the cluster, it thinks it is a new network ... that the SQL IP resource subnet matches the physical IP subnet. ... How to change the network IP addresses of SQL Server failover cluster ...
    (microsoft.public.sqlserver.clustering)
  • Re: Moving SQL Cluster to a new subnet
    ... The key to remember is that your cluster ... always needs a clear communications path for its private communications. ... How to change the network IP addresses of SQL Server virtual servers ... > I need to move a SQL Server Cluster from one subnet to another subnet so I ...
    (microsoft.public.sqlserver.clustering)
  • Database resource wont start after changing cluster subnet
    ... I'm running a SQL Server 2000 SP4 2-node active/acitve cluster on ... I changed the subnet mask ... database resource subnets. ... correctly resolving to the IP addresses for all cluster resources. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Database resource wont start after changing cluster subnet
    ... There's a section in there on how to change the subnet for the resources on ... a SQL Server 2000 failover cluster configuration. ... correctly resolving to the IP addresses for all cluster resources. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Express Remote Connections
    ... So I suggest you to check and double check the instance name on the server where your SQL Server instance is installed and at the client side. ... TCP/IP is enabled (because i can get there from the local subnet) and if i go to the properties of the connection and go to IP Addresses they are all active but only the primary host ip is enabled. ... Check out the setting on configuration manager and check that TCPis enabled, listening out on the correct IP and the correct port. ...
    (microsoft.public.sqlserver.setup)