Add Analysis Services to a clustered SQL Server 2008 instance

views:

2040

answers:

+1 Q:

Add Analysis Services to a clustered SQL Server 2008 instance

Warning: I have never added analysis services to my existing cluster environment.

But this is how i would go about it: 1. Remove one node from cluster ( provided u have > 2 nodes ). 2. Install Analysis services. 3. Bring the node back into cluster.

Nikhil S 2009-07-21 20:57:28

That's what I'm thinking I have to do. I'm afraid I'll still get the error, since the remaining node will still be "cluster-ready", but I'll try this in the morning and post back here.

rwmnau 2009-07-21 23:02:34

Sorry - this didn't work. I still get the error, I assume since the instance is still "cluster-prepared", as the installer puts it. This is driving me nuts! Thanks for the attempt, though.

rwmnau 2009-07-22 15:00:10

+1 A:

Take a look at the SQL Server 2008 Failover Clustering whitepaper.

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

Page 31 & 32

"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."

2009-08-14 19:16:06

This gives me a sad face, but I suppose it's the official answer. I'm not sure how I missed that in the whitepaper, but thanks for the link.

rwmnau 2009-08-14 19:56:35

ansaurus

tags:

views:

answers:

Add Analysis Services to a clustered SQL Server 2008 instance

related questions