Renaming Cluster Nodes -- sql server clustering

RichardT
2/21/2007 9:28:08 PM

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

Aleksandar Grbic
2/22/2007 6:17:16 AM

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

[quoted text, click to view]

Russ Kaufmann [MVP]
2/22/2007 9:15:12 AM

[quoted text, click to view]

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

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server clustering

sql server clustering : Renaming Cluster Nodes