Renaming Cluster Nodes

Realise it is a common question and have searched through the group:
I have a Windows 2003 R2 cluster (with SQL 2000 SP4) which needs to be
renamed (Nodes, cluster name)
Is there any way to bypass re-installing SQL 2000 after this has been
completed?
(Various non microsoft sites point towards using sp_dropserver and
sp_addserver or updating the syservers table)
eg http://blog.opsan.com/archive/2005/05/10/465.aspx
http://msdn2.microsoft.com/en-us/library/aa197071(SQL.80).aspx
Thanks.
why you need rename nodes?
you can change virtual server name but microsoft not recommend this.
do NOT update system tables manually.
if you rename sql server (sp_dropserver and sp_addserver), cluster will not
check sql status and servis will be mark as failure.
best solution: install new sql
Aleksandar Grbic
MCDBA, Senior Database Administrator
"RichardT" wrote:

> Realise it is a common question and have searched through the group:
> I have a Windows 2003 R2 cluster (with SQL 2000 SP4) which needs to be
> renamed (Nodes, cluster name)
> Is there any way to bypass re-installing SQL 2000 after this has been
> completed?
> (Various non microsoft sites point towards using sp_dropserver and
> sp_addserver or updating the syservers table)
> eg http://blog.opsan.com/archive/2005/05/10/465.aspx
> http://msdn2.microsoft.com/en-us/library/aa197071(SQL.80).aspx
> Thanks.
|||"RichardT" <RichardT@.discussions.microsoft.com> wrote in message
news:7DE1DC20-FF62-4B1B-BE0A-6151F11D06F9@.microsoft.com...
> Realise it is a common question and have searched through the group:
> I have a Windows 2003 R2 cluster (with SQL 2000 SP4) which needs to be
> renamed (Nodes, cluster name)
> Is there any way to bypass re-installing SQL 2000 after this has been
> completed?
> (Various non microsoft sites point towards using sp_dropserver and
> sp_addserver or updating the syservers table)
> eg http://blog.opsan.com/archive/2005/05/10/465.aspx
> http://msdn2.microsoft.com/en-us/library/aa197071(SQL.80).aspx
Well, I would start with going back to basics and doing a risk assessment
associated with the change and mitigation strategies. Risk, everything
possible going wrong. Mitigating that risk: Don't make the change as it is
completely unnecessary.
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp
The next ClusterHelp classes are:
NYC starting Feb 19th
London starting March 6th