Groups | Blog | Home
all groups > sql server clustering > november 2005 >

sql server clustering : Computerrename


Mark Bradley
11/11/2005 4:37:25 AM
Your best method for renaming cluster nodes is to fail every thing across to
one of the nodes. Then remove the node with no resources from the cluster and
then rename it. After it has been renamed join the node back to the cluster
move the resources across to the renamed node and repeat the process with the
second node.

Thanks

Mark


[quoted text, click to view]
Rodney R. Fournier [MVP]
11/11/2005 8:10:26 AM
Mark, have you tried this yet? I am not aware of any supported method of
renaming a SQL server (clustered or not).

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training


[quoted text, click to view]

Mark Bradley
11/11/2005 9:13:02 AM
In this case it looked like it was not the instance being renamed only the
nodes name in which case the SQL instance would remain unchanged. Exactley
the same as if you added a new node to a cluster.

Your correct that you have to reinstall to rename the instance but it is
easier and safer to add a new virtual server instance and migrate the data.

As for standalone SQL you can rename it but it can cause problems with any
code using specified name.

Example in books online is incorrect correct article below

http://support.microsoft.com/default.aspx?scid=kb;en-us;303774

Cheers

Mark

[quoted text, click to view]
Rodney R. Fournier [MVP]
11/11/2005 9:23:26 AM
Ok, in that case, his method will work nicely :)

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training


[quoted text, click to view]

Geoff N. Hiten
11/11/2005 9:56:33 AM
He left off the little detail of uninstalling and reinstalling SQL on the
newly renamed node.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

"Rodney R. Fournier [MVP]" <rod@die.spam.die.nw-america.com> wrote in
message news:eTfZnls5FHA.3636@TK2MSFTNGP09.phx.gbl...
[quoted text, click to view]

Stefan Oswald
11/11/2005 11:21:27 AM
Hello,

I have a small question. We have an cluster (W2K) running with an
SQL2000 and an IIS on it. Is it possible to rename the notes of the
cluster without any problems?

Greetings
AddThis Social Bookmark Button