Existing Installation Options

The Existing Installation Options Setup screen includes choices for working with upgrades from previous versions of Microsoft® SQL Server™, as well as upgrades to SQL Server 2000 components. Options that do not apply to your specific setup do not appear on the screen.

Options

Add components to your existing installation

Allows you to add components to an existing installation of SQL Server 2000.

Uninstall your existing installation

Removes an installation (default or named instance) of SQL Server 2000 from your computer. The instance to remove is specified in the Instance Name screen.

Upgrade your existing installation

This option is available for use with existing installations of SQL Server 7.0 and SQL Server 2000. Depending on the version, edition, and component makeup of your existing installation, selecting this option starts the process for one of the following upgrades:

• Upgrade from SQL Server 7.0 to SQL Server 2000. (If you cannot upgrade client tools, see Upgrade Issues below.)
  
  
• Add components to an existing installation of SQL Server 2000. For example, you may have purchased a SQL Server version with more features, or need to install certain components.

Note  Upgrades from SQL Server 6.5 to SQL Server 2000 are run using the SQL Server Upgrade Wizard, available on the SQL Server Start menu.

Upgrade your existing installation to a clustered installation

This option is a step in the process of upgrading from a clustered installation of SQL Server 6.5 or SQL Server 7.0 to a clustered installation of SQL Server 2000. First, the earlier version of SQL Server is upgraded to SQL Server 2000. Next, the existing SQL Server 2000 installation can be upgraded to a cluster. For more information, see Upgrading to a SQL Server 2000 Failover Cluster.

Upgrade Issues

• On a computer running SQL Server 7.0 client tools only, you may encounter the following message when you choose to upgrade your existing installation: "The default instance detected is not able to be upgraded. Please select New Install to upgrade your tools." This issue can occur if you have installed the SQL Server 7.0 client tools by choosing Custom in the Setup Type dialog box, and then by selecting tools in the components dialog box. In this situation, the existing client tools installation of SQL Server 7.0 cannot be upgraded due to registry issues. Instead, you must re-install SQL Server, by selecting Create a new instance of SQL Server, or install Client Tools.
  
  
• You can upgrade a beta version of SQL Server 2000 to the final version of the product by using the option to upgrade your existing installation. If you are performing such an upgrade on a computer or a cluster containing multiple instances, you must first close all instances of SQL Server before upgrading.

See Also

Upgrading from SQL Server 7.0 to SQL Server 2000

Upgrading an Existing Installation of SQL Server

Select Components