Re-named failover nodes for SQL cluster and broke it!

  • Hi all,

    I had a cluster running on 3 nodes (windows failover cluster) with server 2012 and SQL server 2012 running in the cluster. Well, I thought I'd just go ahead and rename all 3 of the hosts with new hostnames and it apparently broke the cluster pretty bad. Now when I open failover cluster manager I cannot see anything nor can I connect to the cluster object in AD. I re-named all of the hosts back to their original names but that didn't help. Any ideas?

  • I guess you're out of luck. Renaming a cluster node, as you have seen, is a very bad idea.

    Do you find anything helpful in the logs?

    Does the Event Viewer contain relevant information?

    Anything listed in the cluster log?

    -- Gianluca Sartori

  • Did you research this any before renaming the nodes, or did you just do this to see what would happen? I hope this is not a production box.

    Check these out. Might provide some good info:

    Rename a SQL Server Failover Cluster Instance

    Rename a Physical Node that is in a 2008 SQL Cluster

    Joie Andrew
    "Since 1982"

  • dgraf (4/17/2014)


    Hi all,

    I had a cluster running on 3 nodes (windows failover cluster) with server 2012 and SQL server 2012 running in the cluster. Well, I thought I'd just go ahead and rename all 3 of the hosts with new hostnames and it apparently broke the cluster pretty bad. Now when I open failover cluster manager I cannot see anything nor can I connect to the cluster object in AD. I re-named all of the hosts back to their original names but that didn't help. Any ideas?

    You cant just rename the nodes!

    Have you tried renaming the nodes back to their original values, see if this gets the cluster back online?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Yes, I have definitely found out that re-naming the physical hostnames is a terrible idea. No, they are not production boxes thank heavens. Perry, yes I tried renaming them back to their original values and it didn't seem to help. I suppose I'll just have start over.

    What is recommended at this point? Should I delete the cluster object out of Active Directory?

  • Hmm renaming should have worked if the old computernames werent removed.

    Trying getting your AD admin to reset the computer accounts for each node (right click in AD and select reset).

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

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