Thursday, December 20, 2012

SQL 2008/R2/2012 Cluster installation error: Failover cluster instance name “ABCDEFGH” already exists as cluster resource?

SQL 2008/R2/2012 Cluster installation error:  Failover cluster instance name “ABCDEFGH” already exists as cluster resource?






Cause:
 Usually this error pops up when you re-install SQL2008/R2/2012 on a cluster (which had SQL2008/R2/2012 instance in the past). Installer will actually checks whether input SQLNetworkName resource is already there in the Cluster, if it finds any orphan resource related then error will be displayed.

Resolution:  when you uninstall the existing SQLServer on Windows 2008/R2 clusters sometimes uninstaller will not completely remove SQL resources from cluster. If you open cluster administrator through GUI you can’t find it so you need to check through command prompt.

Startà Runà CMD – Run as Administrator
At command prompt: type à Cluster res    This command will list you all the resources including orphan resources.
To delete the orphan resource: type à Cluster res <resource name> /delete
< Resource Name – here you need to supply the exact resource name> in case of any dependencies it will prompt and  you need to first delete dependencies and then delete SQLNetworkName resource>
Once you delete SQLNetworkName resource then try re-running the setup.

No comments:

Post a Comment