You cannot add SQL Server components to an existing virtual instance of SQL Server by running the Setup program (867650)



The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)

SYMPTOMS

You installed a virtual instance of Microsoft SQL Server 2000 by using a custom installation, but you did not install some of the SQL Server components, such as Replication Support. You cannot then add those SQL Server components to your virtual instance of SQL Server by running SQL Server Setup again.

WORKAROUND

To work around this problem, you must remove the virtual instance of SQL Server from your computer and then reinstall the virtual instance of SQL Server by using a custom installation. During the installation of the virtual instance of SQL Server, you must select all the SQL Server components that you must have in your virtual instance of SQL Server. To do this, follow these steps:
  1. Detach all user databases or back up all user databases from the virtual instance of SQL Server 2000.
  2. Remove the virtual instance of SQL Server 2000 from your computer.
  3. Reinstall the virtual instance of SQL Server 2000 by using a custom installation. Make sure that you use the same instance name and that you install all the SQL Server components that you must have in your virtual instance of SQL Server.
  4. Attach or restore all user databases to the virtual instance of SQL Server 2000 that you detached or backed up in step 1.

MORE INFORMATION

After you install a virtual instance of SQL Server on your computer, you cannot add the SQL Server components to your virtual instance of SQL Server by running the Setup program. However, if you use a stand-alone instance of SQL Server, you can run the Setup program again to add the SQL Server components.

Steps to reproduce the problem

  1. Run the Setup program to install a virtual instance of SQL Server 2000 on your computer.
  2. On the Setup Type page, click Custom, and then click Next.
  3. On the Select Components page, click to select the Server Component check box in the Components list, and then click to clear the Replication Support check box in the Sub-Components list.
  4. Follow the remaining instructions to complete the installation.

    Note The replication feature of SQL Server is not available for your virtual instance of SQL Server.
  5. Run the Setup program again.
  6. On the Installation Selection page, click the Upgrade, remove, or add components to an existing instance of SQL Server option, and then click Next.
  7. Type the name of your virtual instance of SQL Server in the Instance name box, and then click Next.

    Note On the Existing Installation page, only the Uninstall your existing installation option is enabled. You cannot add the components to your virtual instance.

Modification Type:MinorLast Reviewed:6/29/2004
Keywords:kbsetup kbtshoot kbClustering kbprb KB867650 kbAudDeveloper