How to: Add or Remove Nodes in a SQL Server 2005 Failover Cluster (Setup)

Use this procedure to manage nodes in a Microsoft SQL Server 2005 failover clustered instance.


To update or remove a SQL Server failover cluster, you must be a local administrator with permission to log on as a service on all nodes of the failover cluster.

To add or remove nodes in a SQL Server 2005 failover cluster

  1. Double-click Add or Remove Programs in Control Panel.

  2. Select the SQL Server 2005 component to update, and then click Change. The SQL Server 2005 Installation Wizard starts.

  3. On the Component Selection page, select the SQL Server 2005 instance name to change. Click Next.

  4. On the Feature Maintenance page, select a component to change from within the selected SQL Server 2005 instance. Click Next. The SQL Server 2005 System Configuration Checker starts.

    On the Welcome page, click Next. The System Configuration Checker scans your computer's existing configuration.

  5. After the System Configuration Checker finishes its scan, click Next.

  6. On the Change or Remove Instance page, click Maintain the Virtual Server.

  7. On the Cluster Node Configuration page, specify the nodes to include in the failover cluster instance. To add a node to the failover cluster, select the computer from the Available Nodes list and click Add. To remove a node from the failover cluster, select the computer from the Selected Nodes list and click Remove. Unavailable nodes are displayed in the Unavailable Nodes list, along with the reason for unavailability.

    To create a one-node failover cluster, only the node that will be installed with the failover cluster should be listed in the Required Node list.

    Click Next. For more information, see Cluster Node Configuration.

  8. On the Ready to Update page, review the summary for your SQL Server installation. When you are satisfied with your choices, click Update.

  9. On the Installation Progress page, you can monitor installation progress for individual cluster nodes by selecting a node from the Node list. Setup progress is displayed for the selected node. To view the log file for a component during installation, click the product or status name on the Installation Progress page.

  10. On the Completing the Microsoft SQL Server Installation Wizard page, you can view the Setup summary log by clicking the link provided on this page. To exit the SQL Server Installation Wizard, click Finish.

    If you are instructed to restart the computer, do so now. It is important to follow instructions from the Setup program after installation is complete. Failure to restart any of the specified nodes may cause failures when you run the Setup program again.

  11. All nodes of a failover cluster instance must be at the same version level. After completing SQL Server Setup, you must download and apply the latest SQL Server 2005 service pack and/or patches to ensure that all failover cluster nodes are at the same version level.

See Also


How to: Manually Uninstall a SQL Server 2005 Failover Cluster

Other Resources

How to: View SQL Server 2005 Setup Log Files
How to: Read a SQL Server 2005 Setup Log File

Help and Information

Getting SQL Server 2005 Assistance