Rename SQL Server Virtual name in 2003 Cluster

Is it possible to change the current SQL virtual host name in Windows 2003?
and How?
I tried it by right click on the SQL Network name resource -> properties ->
parameters -> change the name. Then search the registry and change it to a
new name and reboot the node. It works but is there an easy way and is what
I did a safe procedure.
Thanks
Ayad
You sure can, see http://support.microsoft.com/?id=307336 for details
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"Ayad" <ashammout1@.hotmail.com> wrote in message
news:%239vieFHsEHA.760@.tk2msftngp13.phx.gbl...
> Is it possible to change the current SQL virtual host name in Windows
> 2003?
> and How?
> I tried it by right click on the SQL Network name resource ->
> properties ->
> parameters -> change the name. Then search the registry and change it to a
> new name and reboot the node. It works but is there an easy way and is
> what
> I did a safe procedure.
> Thanks
> Ayad
>
|||Thanks Rod. But I don't want to un-install and re-install SQL to change the
name.
Ayad
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:%23X1xRMIsEHA.2732@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> You sure can, see http://support.microsoft.com/?id=307336 for details
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://msmvps.com/clustering - Blog
> "Ayad" <ashammout1@.hotmail.com> wrote in message
> news:%239vieFHsEHA.760@.tk2msftngp13.phx.gbl...
a
>
|||Ok, that's cool. You know you don't have to reinstall. It's right click
rename, then sp_dropserver old_virtualservername
go, sp_addserver new_virtualservername, local go, etc.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"Ayad" <ashammout1@.hotmail.com> wrote in message
news:eEPiKeJsEHA.2904@.TK2MSFTNGP15.phx.gbl...
> Thanks Rod. But I don't want to un-install and re-install SQL to change
> the
> name.
> Ayad
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:%23X1xRMIsEHA.2732@.TK2MSFTNGP09.phx.gbl...
> a
>
|||Hi
Not much choice. Clustering is one of those technologies that you follow the
KB articles exactly otherwise the whole thing comes apart and you end up
re-installing everything.
Sorry.
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Ayad" <ashammout1@.hotmail.com> wrote in message
news:eEPiKeJsEHA.2904@.TK2MSFTNGP15.phx.gbl...
> Thanks Rod. But I don't want to un-install and re-install SQL to change
the[vbcol=seagreen]
> name.
> Ayad
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:%23X1xRMIsEHA.2732@.TK2MSFTNGP09.phx.gbl...
to
> a
>
|||I agree with Mike. The ONLY SUPPORTED way to rename a virtual SQL name is to uninstall and reinstall as documented in Microsoft Knowledge Base article
INF: How to Change a Clustered SQL Server Network Name
http://support.microsoft.com/?kbid=307336
This article has the following important NOTE
"Cluster Administrator provides a method to rename cluster resources. To do this, right-click the resource in Cluster Administrator and click Rename. However, if you
rename the SQL Server Network Name resource, a variety of situations could occur, the most critical being that the SQL Server virtual server instance may no longer come
online. "
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way
to do this is to visit the following websites: http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx