INF: Removing SVS From a Node That SQL Server Was Not Installed On

Article translations Article translations
Article ID: 183960 - View products that this article applies to.
This article was previously published under Q183960
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

SUMMARY

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.

MORE INFORMATION

The following steps describe how to uninstall SVS on a node other than the node that SQL Server was originally installed on:
  1. 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.
  2. Create a System Environment Variable on the node you want to remove SVS from. To do this, perform the following steps:

    1. Open Control Panel, double-click the System icon, and then click the Environment tab.
    2. 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.
    3. Click Set and then click OK to make the change.
  3. Run the SQL Cluster Wizard and choose Remove SVS (the SVS Name from step 2 should be listed here).
  4. 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
  5. 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, 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.

Properties

Article ID: 183960 - Last Review: October 7, 2013 - Revision: 1.0
APPLIES TO
  • Microsoft SQL Server 6.5 Enterprise Edition
Keywords: 
kbnosurvey kbarchive kbinfo KB183960

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com