This article was previously published under Q183960
This article has been archived. It is offered "as is" and will no longer be updated.
The Whatsnew document from Microsoft SQL Server 6.5 Enterprise Editionstates that for a Symmetric Virtual Server (SVS) to be removed oruninstalled, the SQL Cluster Wizard must be run from the node that SQLServer was originally installed on. This article describes how to removeSVS from a node where SQL Server was not installed.
The following steps describe how to uninstall SVS on a node other than thenode 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 it from.
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 Environment tab.
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:
157805 : BUG: RegistryRebuild Option of Setup Is Not Documented
Additionally, if you wish to reinstall the SVS from this same node, confirmthat the SQL Server global variable @@servername matches this node'smachine and/or network name and then run SQL Cluster Wizard to install the SVS.