The Whatsnew document from Microsoft SQL Server 6.5 Enterprise Edition
states that for a Symmetric Virtual Server (SVS) to be removed or
uninstalled, the SQL Cluster Wizard must be run from the node that SQL
Server was originally installed on. This article describes how to remove
SVS from a node where SQL Server was not installed.
The following steps describe how to uninstall SVS on a node other than the
node that SQL Server was originally installed on:
- Use the Cluster Administrator utility to move the SVS group that you
want to uninstall to the node of the cluster that you want to uninstall
- Create a System Environment Variable on the node you want to remove SVS
from. To do this, perform the following steps:
- Open Control Panel, double-click the System icon, and then click the
- Click in the System Variables section and then type the name and
value (in the Variable and Value fields respectively) at bottom of
the dialog box. The name of the variable to use is
"_VIRTUAL_SERVER_NAME_" (without The quotation marks) and the value
needs to be the SVS Name you want to remove.
NOTE: If this variable already exists, change the value to the SVS
Name that you want to remove.
- Click Set and then click OK to make the change.
- Run the SQL Cluster Wizard and choose Remove SVS (the SVS Name from step
2 should be listed here).
- Run the following command from the I386\Cluster directory of the SQL
Server 6.5 Enterprise Edition CD:
apfsql -u <drive and path to SVS install binn directory>
For example, if SVS is installed on the S drive (a shared drive) using
the default installation, you would run this command:
apfsql -u s:\mssql\binn
- SQL Server should start as a normal service. For additional information
and instructions (if SQL Server does not start as a normal service),
please see the following article in the Microsoft Knowledge Base:
: BUG: RegistryRebuild Option of Setup Is Not Documented
Additionally, if you wish to reinstall the SVS from this same node, confirm
that the SQL Server global variable @@servername matches this node's
machine and/or network name and then run SQL Cluster Wizard to install the SVS.
Article ID: 183960 - Last Review: December 12, 2002 - Revision: 1.0
- Microsoft SQL Server 6.5 Enterprise Edition
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.