Post reply

rename hostname in SQL server cluster

  • March 24, 2015 at 12:00 am

    #398226

    Good Day,

    Kindly i need your interaction and support regarding below case :

    I have Cluster SQL Server 2008 R2 with 2 Nodes :

    Node1 : sqlserver2

    Node2 : sqlserver3

    Operating system want to rename Node 2 : sqlserver3 and make it sqlserver1

    what is the impact on my SQL server cluster and how to update my SQL server cluster with the new Name

    Regards,

  • March 24, 2015 at 1:27 am

    #1785886

    any reply

  • March 24, 2015 at 6:16 am

    #1785926

    Any Update please

  • March 24, 2015 at 6:40 am

    #1785929

    i think google is probably your friend on this one: i think this one was the better resource than anything i got from MSDN

    http://windowsitpro.com/windows-server/rename-nodes-cluster

    i've never done it, but the article above says these are the steps.

    Q: I have a cluster and want to change the name of hosts in the cluster; is this OK?

    A: To change the name of a host in a cluster, you should evict the node from the cluster, rename the node, then add back to the cluster. This means the process is as follows:

    1. Move all the resources running on the node to be renamed to other nodes in the cluster. This can be done through Failover Cluster Manager by selecting the Pause option and selecting Drain Roles.

    2. Within Failover Cluster Manager, right-click the node to be evicted in the Nodes area and select More Actions, Stop Cluster Service.

    3. Right-click the node again and select More Actions, Evict.

    4. On the evicted node, use the Control Panel System applet to rename the server.

    5. After the server is renamed, add it back to the cluster using the Nodes, Add Node action.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • March 24, 2015 at 6:48 am

    #1785932

    Many Thanks

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply