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



The information in this article applies to:

  • Microsoft SQL Server, Enterprise Edition 6.5

This article was previously published under Q183960

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.

Modification Type:MajorLast Reviewed:12/12/2002
Keywords:kbinfo KB183960 kbAudDeveloper