April 7, 2011 at 8:08 pm
I was given a cluster to manage that has Analysis Services installed (Windows Server 2003 x64, SQL Server 2005 Enterprise)
I ran the SP4 update for SQL 2005 and everything upgraded except Analysis Services. Actually SSAS did upgrade on one node of the cluster, but not the other.
Looking at Cluadmin it seems clear that SSAS is not clustered. During the install of SQL on a cluster, there is the option to install SSAS, and then if that is checked, there is the option to "Create an analysis services failover cluster". Presumably whoever installed this did not check that box.
So my question is: can this instance of Analysis Service, that is currently only running on one node, be upgraded to a clustered instance? (This is a production server, so I always need to make the minimum changes possible.) Or do I have to uninstall the current instance, and reinstall a clustered instance?
April 7, 2011 at 11:53 pm
You can't turn it into a clustered version, you'll have to install another instance of Analysis Services into the cluster. You don't have to remove the existing standalone one first though; they will be independent instances. One issue could be that the clustered instance will have a different name and you will have to change your reports etc to point to the new name.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply