DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 922670 - Last Review: November 20, 2007 - Revision: 2.5

On This Page

INTRODUCTION

This article describes how to use the Add or Remove Programs item in Control Panel to add or remove components on stand-alone and clustered installations of Microsoft SQL Server 2005.

MORE INFORMATION

After you install SQL Server 2005, the Setup program creates several entries in the Currently installed programs list in Add or Remove Programs. The Microsoft SQL Server 2005 entry is a starting point to add or remove components of SQL Server 2005. However, you should be aware of certain differences in using the Add or Remove Programs item for stand-alone installations and for clustered installations of SQL Server 2005.

Add or Remove Programs in stand-alone installations of SQL Server 2005

For a stand-alone installation of SQL Server 2005, you can use the Add or Remove Programs item to perform the following actions.

Add a new component to an existing SQL Server 2005 installation

You may want to add a new component, such as SQL Server 2005 Analysis Services or SQL Server 2005 Reporting Services. To do this, follow these steps:
  1. In Control Panel, open Add or Remove Programs.
  2. In the Currently installed programs list, click Microsoft SQL Server 2005, and then click Change. The SQL Server 2005 Maintenance Wizard starts.
  3. On the Component Selection page, click To install a new component, click here.
  4. When you are prompted to provide the location of the Setup.exe file in the SQL Server 2005 installation media, specify the correct path.
  5. Click OK. The regular SQL Server 2005 Setup program starts.
  6. Click Next on subsequent screens and provide the required information.
  7. On the Component to Install page, select the component that you want to install.
  8. Click Next, and then complete the wizard.

Remove a component from an existing SQL Server 2005 installation

You may want to remove a component, such as the Workstation components or SQL Server 2005 Reporting Services. To do this, follow these steps:
  1. In Control Panel, open Add or Remove Programs.
  2. In the Currently installed programs list, click Microsoft SQL Server 2005, and then click Change. The SQL Server 2005 Maintenance Wizard starts.
  3. On the Component Selection page, under the SQL Server 2005 instances node, select the instance that includes the instance of the component that you want to remove. For example, if you want to remove SQL Server 2005 Analysis Services from an instance, click the instance name.

    Note You may want to remove Full-Text Search. Full-Text Search is a part of the Database Engine. To do this, click the item that has Database Engine listed. If you want to remove common components such as SQL Server 2005 Integration Services, SQL Server 2005 Notification Services, or Workstation components, click the component under the SQL Server 2005 common components node.
  4. Click Next. The SQL Server 2005 Maintenance Wizard starts the SQL Server 2005 Installation Wizard.
  5. Click Next several times until the Change or Remove Instance page appears.
  6. On the Change or Remove Instance page, click Change Installed Components.
  7. Click Next.
  8. On the Feature Selection page, notice the component that you selected earlier. Click the component that you want to remove, and then click Entire feature will be unavailable.
  9. Click Next, and then complete the wizard.

Completely remove an existing SQL Server 2005 installation

To completely remove SQL Server 2005 installation from the computer, follow these steps:
  1. In Control Panel, open Add or Remove Programs.
  2. In the Currently installed programs list, click Microsoft SQL Server 2005, and then click Remove. The SQL Server 2005 Maintenance Wizard starts.
  3. On the Component Selection page, under the SQL Server 2005 instances node, select the instance of SQL Server 2005 that you want to remove from the computer.

    Note The Remove SQL Server 2005 common components list includes the common components that are used by all instances of SQL Server 2005 on the computer. Only select to remove these common components if you are sure that no other instances on the computer need the components. Remember that common components such as SQL Server 2005 Integration Services, SQL Server 2005 Notification Services, and Client Tools are only installed one time on the same computer, regardless of the number of instances of SQL Server 2005.
  4. Click Next, and then complete the wizard.

Add or Remove Programs in clustered installations of SQL Server 2005

For a clustered installation of SQL Server 2005, the Add or Remove Programs item only lets you add or remove the nodes in a cluster or remove the whole installation.

You cannot use the Add or Remove Programs item on a cluster to add or remove cluster-aware SQL Server components. For example, you cannot use the Add or Remove Programs item on a cluster to add or remove SQL Server 2005 Database Engine or SQL Server 2005 Analysis Services. You can only run the Setup program at a command prompt to add or remove SQL Server components.

Notice that if you try to install a new SQL Server component from an active cluster node by using Add or Remove Programs, the installation wizard will not report an error. However, the installation wizard will fail in the end during the installation. You must only use the Setup program at a command prompt to add or remove SQL Server components on a cluster.

For more information about how to use the command prompt to add SQL Server components to a SQL Server 2005 clustered installation, visit the following Microsoft Developer Network (MSDN) Web site:
http://msdn2.microsoft.com/en-us/library/ms144259.aspx (http://msdn2.microsoft.com/en-us/library/ms144259.aspx)
Notice that you can still use the Add or Remove Programs item to add non-cluster aware components to a cluster. For example, you can use the Add or Remove Programs item to add SQL Server 2005 Notification Services, SQL Server 2005 Integration Services and Workstation components. You cannot use Add or Remove Programs to add the cluster-aware components. Similarly, you cannot use the Add or Remove Programs item to remove a SQL Server component on a cluster. For example, you cannot use the Add or Remove Programs item to remove SQL Server 2005 Database Engine, SQL Server 2005 Analysis Services or any of their sub-components on a cluster. The only supported method for removing an existing SQL Server component from the existing clustered installation of SQL Server 2005 is by running the Setup program at a command prompt. For more information about how to use command prompt to remove components from a cluster, visit the following MSDN Web site:
http://msdn2.microsoft.com/en-us/library/ms144259.aspx (http://msdn2.microsoft.com/en-us/library/ms144259.aspx)
. You can still use Add or Remove Programs to remove non-cluster aware components on a cluster. However, you cannot use Add or Remove Programs to remove the cluster-aware components on a cluster.

Add or remove nodes from an existing SQL Server 2005 clustered installation

The Add or Remove Programs item in Control Panel on a cluster is designed for cluster maintenance purposes. You should use the Add or Remove Programs item to add or remove any nodes for the existing clustered installation of SQL Server 2005.

For more information about how to do this, visit the following MSDN Web site:
http://msdn2.microsoft.com/en-us/library/ms191545.aspx (http://msdn2.microsoft.com/en-us/library/ms191545.aspx)

Completely remove an existing clustered installation of SQL Server 2005

You can use the Add or Remove Programs item in Control Panel to completely uninstall an existing clustered installation of SQL Server 2005. For more information about how to do this, visit the following MSDN Web site:
http://msdn2.microsoft.com/en-us/library/ms190438.aspx (http://msdn2.microsoft.com/en-us/library/ms190438.aspx)

APPLIES TO
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Standard Edition for Itanium-based Systems
  • Microsoft SQL Server 2005 Standard X64 Edition
Keywords: 
kbhowto kbexpertiseadvanced kbsql2005setup kbinfo KB922670
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support