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 (AT) hotmail (DOT) com> wrote

Thanks Rod. But I don't want to un-install and re-install SQL to change the
name.

Ayad

"Rodney R. Fournier [MVP]" <rod (AT) die (DOT) spam.die.nw-america.com> wrote in
message news:%23X1xRMIsEHA.2732 (AT) TK2MSFTNGP09 (DOT) phx.gbl...

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 (AT) hotmail (DOT) com> wrote

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 (AT) epprecht (DOT) net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Ayad" <ashammout1 (AT) hotmail (DOT) com> wrote

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