| Author |
Message |
Stefan Oswald
Guest
|
 Posted:
Fri Nov 11, 2005 1:50 pm Post subject:
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 |
|
| Back to top |
|
 |
Mark Bradley
Guest
|
| Posted:
Fri Nov 11, 2005 1:50 pm Post subject:
RE: Computerrename |
|
|
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:
| Quote: | 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
|
|
|
| Back to top |
|
|
Rodney R. Fournier [MVP]
Guest
|
| Posted:
Fri Nov 11, 2005 5:50 pm Post subject:
Re: Computerrename |
|
|
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...
| Quote: | 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
|
|
|
| Back to top |
|
|
Geoff N. Hiten
Guest
|
| Posted:
Fri Nov 11, 2005 5:50 pm Post subject:
Re: Computerrename |
|
|
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...
| Quote: | 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...
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
|
|
|
| Back to top |
|
|
Rodney R. Fournier [MVP]
Guest
|
| Posted:
Fri Nov 11, 2005 5:50 pm Post subject:
Re: Computerrename |
|
|
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...
| Quote: | 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...
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
|
|
|
| Back to top |
|
|
Mark Bradley
Guest
|
| Posted:
Fri Nov 11, 2005 5:50 pm Post subject:
Re: Computerrename |
|
|
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
"Rodney R. Fournier [MVP]" wrote:
| Quote: | 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...
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...
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
|
|
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in