Results 1 to 5 of 5

Thread: change subnet and IP on clustered servers

  1. #1
    Join Date
    Nov 2002
    Posts
    24

    Question change subnet and IP on clustered servers

    According to Microsoft, if you need to change the subnet for the clustered servers, you will need to either edit the registry or reinstall virtual SQL Server.

    Does any one know which registry key(s) store the subnet information? I was reviewing the clustered key but was able to find the key for the IP address only.

    Thanks ...byyu

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Don't have to, you can do it in cluster administrator.

  3. #3
    Join Date
    Sep 2002
    Posts
    169
    Be very careful when making changes in a clustered server environment. If you don't use tools that are cluster aware, you will very quickly cause serious damage to the cluster.

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    I did this with cluster administrator and never had any problem.

  5. #5
    Join Date
    Nov 2002
    Posts
    24

    What is the best approach to change IP and subnet for clustered SQL Servers

    Thank you.

    I have also posted the following question in the "Ask the Expert" forum as I couldn't find this forum earlier (overwhelm by my workload).

    Can someone shares your opinions?

    To relocate the clustered servers which requires changing the IP and subnet, our internal Windows 2000 team suggested to perform the following steps:

    Upon arrival in the new location,
    1. Boot up node #1, use the SQL Setup CD to change the SQL virtual Server IP and subnet.
    2. Then, change the Cluster IP, subnet and shut down the box.
    3. Start up the second node.
    4. Use SQL setup CD to change virtual IP and subnet on the second node.
    5. Change the second nodes' cluster IP and subnet.
    6. Restart both nodes one by one.

    Can someone validate whether the above approach works and safe; what other strategies are available; and which approaches are the best??

    Thanks...byyu


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •