SQL 2008 Clustered Environment Upgrade SSAS Error
Posted on 2014-04-21
I am trying to upgrade a SQL 2008 clustered environment with two servers to SQL 2012.
I have left the cluster active, but have removed the ability for the database to fail over from the active to the passive node. I am trying to install SQL 2012 on the passive node first.
I make it through all of the pre-requisite checks without issue. The installer begins, then fails out with the error: "The cluster resource is not online. Bring the Analysis Services server online before starting the upgrade process."
I cannot get past this error. In looking at the services on the passive node I am trying to update, SSAS is not started. When I try to start it it immediately shuts down again. I assume this is because the node is passive.
SSAS is running on the active node and I have verified it is in good working condition by restarting the service on the active node without issue.
I am not sure whether or not SSAS can normally be started on the passive node, or whether SSAS only runs when the node is active.
Is there a way to start SSAS on the passive node to do the upgrade; or, is there some other way to get around this error message?