Sunday, March 25, 2012

Computerrename

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
Stefan
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
"Stefan Oswald" wrote:

> 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
> Stefan
>
|||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
"Mark Bradley" <MarkBradley@.discussions.microsoft.com> wrote in message
news:8C1A89C9-16CE-4467-A770-721197B4A7EF@.microsoft.com...[vbcol=seagreen]
> 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
>
> "Stefan Oswald" wrote:
|||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...
> 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
>
> "Mark Bradley" <MarkBradley@.discussions.microsoft.com> wrote in message
> news:8C1A89C9-16CE-4467-A770-721197B4A7EF@.microsoft.com...
>
|||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
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:eJJfPBt5FHA.1864@.TK2MSFTNGP12.phx.gbl...
> 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...
>
|||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...b;en-us;303774
Cheers
Mark
"Rodney R. Fournier [MVP]" wrote:

> 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
>
> "Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
> news:eJJfPBt5FHA.1864@.TK2MSFTNGP12.phx.gbl...
>
>

No comments:

Post a Comment