We have a sql 2005 cluster on W2K8 cluster. It is a named instance say SRV1\A. Then I built a new W2K8 (with a diff cluster service name) but the same service account. Then I installed a new sql 2005 cluster say SRV2\A. Now when I bring down the sql server resources on SRV1 and try to rename SRV2\A to SRV1\A through the cluster admin, I get the error the network name already exists. I have tried bringing an old cluster and installing a new cluster with the same name and it works. Why am I not able to rename the name? Any advice would very helpful.
Allan Hirt is his book on SQL2005 High Availability advises you can only rename the stuff in DNS - so a named instance such as Crystal\ball, you can only rename Crystal.
On Google Books, look for ISBN 159059780x - and then look at page 334.
So what Allan Hirt is saying is that it is not possible with SQL2005 to rename the instance name - without doing an uninstall and reinstall.