Cluster Server Rename

Is there an easy way to rename the Cluster Server Name ?
What about renaming the underlying physical nodes as well ?
Can this easily be done or does this call for an entire Cluster rebuild ?
Using SQL 2K and Windows 2003
you can rename your cluster :
http://technet2.microsoft.com/WindowsServer/en/library/3423f079-753c-4066-a998-26bf274298f41033.mspx?mfr=true
you can not rename the individual nodes, unless you evict them from the
cluster, rename the nodes, and add them to the cluster
"Hassan" <Hassan@.hotmail.com> wrote in message
news:%23MLZr5IBHHA.1220@.TK2MSFTNGP04.phx.gbl...
> Is there an easy way to rename the Cluster Server Name ?
> What about renaming the underlying physical nodes as well ?
> Can this easily be done or does this call for an entire Cluster rebuild ?
> Using SQL 2K and Windows 2003
>
|||SQL 2000 does not allow you to rename the SQL Virtual Instance name.
Everything else Edwin has correct.
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"Hassan" <Hassan@.hotmail.com> wrote in message
news:%23MLZr5IBHHA.1220@.TK2MSFTNGP04.phx.gbl...
> Is there an easy way to rename the Cluster Server Name ?
> What about renaming the underlying physical nodes as well ?
> Can this easily be done or does this call for an entire Cluster rebuild ?
> Using SQL 2K and Windows 2003
>
|||So how does one go about renaming the SQL Virtual ?
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:OH$Z4CQBHHA.1220@.TK2MSFTNGP04.phx.gbl...
> SQL 2000 does not allow you to rename the SQL Virtual Instance name.
> Everything else Edwin has correct.
> Cheers,
> Rodney R. Fournier
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://www.msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
> ClusterHelp.com is a Microsoft Certified Gold Partner
>
> "Hassan" <Hassan@.hotmail.com> wrote in message
> news:%23MLZr5IBHHA.1220@.TK2MSFTNGP04.phx.gbl...
>
|||With SQL 2000? Start all over
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"Hassan" <Hassan@.hotmail.com> wrote in message
news:%23dn3NXhBHHA.3560@.TK2MSFTNGP04.phx.gbl...
> So how does one go about renaming the SQL Virtual ?
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:OH$Z4CQBHHA.1220@.TK2MSFTNGP04.phx.gbl...
>
|||the question was about rename cluster, not renaming named instance
;-)
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:OH$Z4CQBHHA.1220@.TK2MSFTNGP04.phx.gbl...[vbcol=seagreen]
> SQL 2000 does not allow you to rename the SQL Virtual Instance name.
> Everything else Edwin has correct.
> Cheers,
> Rodney R. Fournier
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://www.msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
> ClusterHelp.com is a Microsoft Certified Gold Partner
>
> "Hassan" <Hassan@.hotmail.com> wrote in message
> news:%23MLZr5IBHHA.1220@.TK2MSFTNGP04.phx.gbl...
?
>
|||Trying to add value and guess the next question, in this case I was correct

Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"Edwin vMierlo" <EdwinvMierlo@.discussions.microsoft.com> wrote in message
news:u2Vr0PwBHHA.5064@.TK2MSFTNGP02.phx.gbl...
> the question was about rename cluster, not renaming named instance
> ;-)
>
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:OH$Z4CQBHHA.1220@.TK2MSFTNGP04.phx.gbl...
> ?
>
|||See this article for renaming SQL 2005 virtual server name:
http://msdn2.microsoft.com/en-US/library/ms178083.aspx
However, you cannot rename SQL 2000 virtual server name.
"Rodney R. Fournier [MVP]" wrote:

> Trying to add value and guess the next question, in this case I was correct
>
> Cheers,
> Rodney R. Fournier
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://www.msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
> ClusterHelp.com is a Microsoft Certified Gold Partner
>
> "Edwin vMierlo" <EdwinvMierlo@.discussions.microsoft.com> wrote in message
> news:u2Vr0PwBHHA.5064@.TK2MSFTNGP02.phx.gbl...
>
>

Cloned Drive

I have a machine named DOG with MSDE (computername=DOG). I clone the machine
to another and rename the machine CAT. When I do this, SQL Server reports
"Your SQL Server installation is either corrupt or has been tampered with
(unknown package id). Please rerun setup." I understand why this happens,
the computername changed.
Is there a way to change the package id to work with the new computername?
Of course I can reinstall MSDE, but that defeats the mai purpose of the
clone.
TIA,
Will
hi Will,
Will T wrote:
> I have a machine named DOG with MSDE (computername=DOG). I clone the
> machine to another and rename the machine CAT. When I do this, SQL
> Server reports "Your SQL Server installation is either corrupt or has
> been tampered with (unknown package id). Please rerun setup." I
> understand why this happens, the computername changed.
> Is there a way to change the package id to work with the new
> computername? Of course I can reinstall MSDE, but that defeats the
> mai purpose of the clone.
to the best of my knowledge, this was a problem with SQL Server 7.0 and MSDE
1.0(http://support.microsoft.com/default...b;en-us;229875), as SQL
Server 7.0 could be "managed" rerunning the setup (
http://databasejournal.com/features/...0894_2194711_3 ),
where no work around was available for MSDE 1.0...
for SQL Server 2000, if you change the computer name, you only need to
delete and re-create the server registration in Enterprise Manager, but as
MSDE doew not provide it, you need nothing on MSDE 2000...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply