SQL Server 2000 IP address and subnet change

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

I have to move a SQL Server 2000 active/passive cluster from one subnet to
another in the same domain. I've read the relevant Q244980 and Q230356
articles but still want to be sure that I am doing this correctly as I do not
find the articles to be completely clear.
Our cluster has two nodes, each with one public and one private adapter. As
well as the virtual SQL instance's IP address there is a cluster group for
MSDTC which also has an address.

Is it simply a matter of changing the IP and subnet masks for each nodes
public adaper and then going into cluster administrator (assume that I can
connect to ".") and changing the Cluster , SQL instance and MSDTC's IP and
subnet mask ?

Sincerely
Tony Dawson





.

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: Issues creating a new failover cluster on the same server
    ... G:\Microsoft SQL Server\MSSQL.1 ... CHNSQL04 Cluster Group ... Drives: H and F ... Group, the MS DTC Group, and each of the SQL Server Instance Groups running ...
    (microsoft.public.sqlserver.clustering)
  • Re: Clustering Newbie - SAN Advice
    ... Senior SQL Infrastructure Consultant ... SAN/Smart array or through a fibre channel switch. ... The SAN or Smart array will dictate what internal connection the disks ... single-instance cluster. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Clustering Question
    ... You could make a test environnement through Virtual Machine to get a picture on Cluster. ... I have worked with Windows 2003 Small Business Server, Exchange Server 2003 and 2000 SQL server but not in a clustered environment. ... > you cannot install Cluster on a Small Business Edition, ...
    (microsoft.public.windows.server.clustering)
  • Re: SQL server 2005 SP2 failing on cluster
    ... We have been told for a long time that MSDTC is optional on a cluster but is all but required in the real world. ... I'm having problem to update my SQL cluster with SQL server 2005 SP2. ... Package Platform: x86 ... see Help and Support Center at ...
    (microsoft.public.sqlserver.clustering)