September 12, 2013 at 2:23 am
I need to install SSAS as an extra feature on a 2 node SQL Cluster.
This will have to run as a separate instance, what is the process to get it installed. Are there any gotcha’s
I imagine I need to pause the node and install SSAS. The failover and do the same?
September 12, 2013 at 4:28 am
Talib123 (9/12/2013)
I need to install SSAS as an extra feature on a 2 node SQL Cluster.This will have to run as a separate instance, what is the process to get it installed. Are there any gotcha’s
I imagine I need to pause the node and install SSAS. The failover and do the same?
Unfortunately, as far as I am aware, you can not just simply add SSAS a feature to an existing database cluster due to the cluster resourse group already being in use, the install wizard will fail. what I would do is remove your passive node(s) from the cluster and install analysis services and then re add the nodes, I think this should work.
September 12, 2013 at 7:40 am
You should also be aware that SSAS is not Cluster Aware and that clustering SSAS is not a recommended practice.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 12, 2013 at 8:14 am
Jack Corbett (9/12/2013)
You should also be aware that SSAS is not Cluster Aware and that clustering SSAS is not a recommended practice.
SSAS is cluster aware from SQL 2008 onwards
http://technet.microsoft.com/en-us/library/dd207001(v=sql.105).aspx
You could also do it in SQL 2005 but with a different method from what we do now.
http://technet.microsoft.com/en-us/library/ms143511(v=sql.90).aspx
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply