Remove Analysis services alone from a 2008 cluster

• Nimesh T Mathews

  Right there with Babe

  Points: 727

  More actions

  January 19, 2011 at 4:39 am

  #233433

  I have 2008 Analysis Services installed on a two node SQL Server 2008 cluster (along with db engine). How do I remove this service from the cluster?

  I tried the add/remove programs and command line option and both end up with the message: "The selected instance is clustered and cannot be removed as specified. To remove the selected instance, select "Remove Node" on the Installation Center or specify /Action=RemoveNode from the command line."

  I tried removing one node hoping I could then uninstall from the only remaining node but still could not remove AS. I tried deleting Analysis Services resource from the SQL Server resource group. Although this would allow me turn off the service, it still would not let me uninstall it.

  Removing both nodes and reinstalling seems harsh just remove a service. I guess just deleting the resource from the cluster and turning off the service is good enough.

  Any other ideas is appreciated.