Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. You cannot add or remove features to a SQL Server 2008, SQL Server 2008 R2, or SQL Server 2012 failover cluster

You cannot add or remove features to a SQL Server 2008, SQL Server 2008 R2, or SQL Server 2012 failover cluster

View products that this article applies to.

Summary

Microsoft SQL Server 2008, Microsoft SQL Server 2008 R2, and Microsoft SQL Server 2012 do not support adding or removing features or components to or from an existing failover cluster instance. For example, you cannot add the Database Engine to an existing Analysis Services-only failover cluster, nor can you add Analysis Services to an existing Database Engine-only failover cluster. On the same note, removing features from a clustered instance is also not supported.

Note This issue also affects editions of SQL Server that have been upgraded. For example, this issue will occur with editions of SQL Server that have been upgraded as follows:
  • You upgrade from SQL Server 2008 to SQL Server 2008 R2 or to Microsoft SQL Server 2012.
  • You upgrade from SQL Server 2008 R2 to SQL Server 2012.

↑ Back to the top

More Information

The option to add or remove features is not supported either when you run the setup through SQL Server Installation Center or when you run the setup from a command prompt. For more information on what happens when you try to add a feature through setup, you can refer to the following forum post:
Why do I get 'Rule "Existing clustered or clustered-prepared instance" failed' error while adding new features to an existing instance of SQL Server Failover Cluster?
If you need to add or remove features to an existing installation, you must reinstall the virtual instance with the required features. For additional information, you can refer to the following topics in SQL Server Books Online:Note The SQL Server Analysis Services resource is a part of any SQL Server failover cluster’s resource group where Analysis Services is installed. Although it is possible to install both Database Engine and Analysis Services in the same resource group, it is generally recommended to install them as separate instances. Analysis Services is not dependent on SQL Server, and it should be installed to a separate resource group for maximum availability and performance.

↑ Back to the top

Keywords: kb, kbsurveynew, kbtshoot, kbexpertiseinter

↑ Back to the top

Article Info
Article ID : 2547273
Revision : 1
Created on : 1/7/2017
Published on : 7/24/2014
Exists online : False
Views : 371