How add Analysis Services to a clustered SQL Server instance ?
It’s not supported to Add or Remove features for Clustered instances
SQL Server setup 2012 does not support adding features to an existing failover cluster instance. By using the wizard, you will get the following error message:
– Instance name ‘<Instance Name>’ is already in use. To continue, specify a unique instance name.
– The SQL Server failover cluster instance name ‘<virtual name>’ already exists as a clustered resource. Specify a different failover cluster instance name.
Analysis Services cannot be added to an existing instance of SQL Server. To share a resource group with an instance of SQL Server, you must choose to install Analysis Services during the initial installation of SQL Server. On the same note removing features from a clustered instance is also not supported.
Reference regarding old version: You cannot add or remove features to a SQL Server 2008 or SQL Server 2008 R2 failover cluster
Michel Degremont | Premier Field Engineer – SQL Server Core Engineer |