Adding SSAS (SQL Server Analysis Service) to an Existing Cluster


I have already installed SQL Server in failover cluster. Which consists of two nodes.

I have requirements which need SSAS (SQL Server Analysis Service) and SSRS (SQL Server Reporting Service)

After many tries, I failed!!!

After some search… I found the following line in SQL Server 2008 R2 White Paper

Note: SQL Server 2008 does not support adding features to an existing failover cluster instance, so 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.

http://download.microsoft.com/download/6/9/D/69D1FEA7-5B42-437A-B3BA-A4AD13E34EF6/SQLServer2008FailoverCluster.docx

In shourcut: you can’t install  SSAS or SSRS on an existing cluster.

Solution

Adding third or new node (server) to the cluster and install on this node the SSAS and SSRS. (this solution is my suggestion)

Advertisements

One thought on “Adding SSAS (SQL Server Analysis Service) to an Existing Cluster

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s