How to remove a SQL Cluster Resource Group from AD

  • Hello,

    I needed to remove a resource group out of a clustered windows 2008 setup. In sql I made sure that the resource was empty and then deleted it. I'd like to recreate the group and start again, but at the last part of the install I am getting an error that the object already exists. Is there a way I can clean this up and reuse the name and the IP address for the group and recreate it?

    Regards,

    D.

  • OK, I'm slightly confused here!!

    Duran (10/22/2010)


    I needed to remove a resource group out of a clustered windows 2008 setup. In sql I made sure that the resource was empty and then deleted it.

    Are you saying you have deleted the resource group in Failover cluster manager?

    Duran (10/22/2010)


    I'd like to recreate the group and start again, but at the last part of the install I am getting an error that the object already exists. Is there a way I can clean this up and reuse the name and the IP address for the group and recreate it?

    Regards,

    D.

    What object does it say already exists? You will need to remove the virtual network name from DNS and from Active Directory.

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

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

  • Was this a failed install, or an install/uninstall? Did the SQL Uninstaller remove the group, or did you do it manually, and was this before or after you ran the uninstall?

  • Hello,

    Perry, yes I deleted the resource group from cluster manager, I removed the drive from the resource group beforehand and there were no SQL instances in there. I had a feeling I'd need to remove the name from DNS (although I do not receive a reply when I ping the name or the IP address) and from AD, I expect I will be able to get someone here to remove it from DNS if its there but I cannot for the life of me find it in AD. Do you know where it will be located in Active Directory?

    Derrick, yes it was a failed install, I removed it manually after running the uninstall of the instance.

    The actual error message I am getting when I try to redo everything is as follows

    The resource 'SQL IP Address 1 (<networkname>)' of type 'IP Address' could not be created in group '<ResourceGroupName>'. Error: The object already exists. (Exception from HRESULT:0x80071392)

    I cant find anything on the web regarding this, so your help would be invaluable.

    Regards,

    D.

  • it would default to the Computers OU but could be moved almost anywhere. Go into AD users and computers console and in the left pane right click the domain and select Find. Search for the network name here

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

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

  • Hey all,

    Ok, I have come to the conclusion that there does not appear to be any solution to this error. I deleted the entry in AD Computers OU (thank you Perry), and also removed the entry from DNS, but this did not solve the problem. Basically I need to cleanse the system totally of the SQL network name and IP address. Set up constantly comes back stating that the network name already exits in the resource group just as it gets to cluster_IP_addres_cluster_config_Cpu64 part of the installation.

    Regards,

    D.

  • Hello,

    A breakthrough, talk about barking up the wrong tree. The reason why the network name cant be used is because having ran Cluster Res on the command line I notice that the network name I want to use is already pointing to another resource group. The reason this has happened is because at one stage I decided to match up the network names with the resource group name. I did follow an article on how to do this, but the changes are obviously not reflected in the Quorum.

    So, if there is no way of repointing it in the quorum, I may just uninstall the first instance I did, delete the resource group and reinstall them again to straighten it up. Do you think that is my best course of action? Fiddling around inside the Quorum doesnt sound very clever, though I doubt its even possible anyway.

    Regards,

    D.

  • Duran (10/25/2010)


    having ran Cluster Res on the command line I notice that the network name I want to use is already pointing to another resource group.

    Is it really that much trouble to just pick a new network name and IP for the instance??

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

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

  • Hello,

    I know what you mean, I just wanted everything to be uniform.

    Regards,

    D.

  • Duran (10/26/2010)


    Hello,

    I know what you mean, I just wanted everything to be uniform.

    Regards,

    D.

    I can understand that, but you're making a whole lot of extra work for yourself. What if the uninstall doesn't go as planned, you will just compound things even further!

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

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

  • Hello,

    Yes, I considered the uninstall process not going as I would have liked it so I went ahead and installed and extra instance as you suggested, now I've done it I feel it was the right choice. Thanks.

    Regards,

    D.

Viewing 11 posts - 1 through 11 (of 11 total)

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