Sql-server – Unable to Upgrade SQL Server from 2012 to 2016 SP2 in Cluster environment

sql server

I have a Windows 2012 R2 Datacenter cluster environment.
With active Passive nodes of SQL Server 2012 SP4.

I am trying to upgrade the SQl Server from 2012 SP4 to 2016 SP2.
I am performing in-place upgradation first on Passive node and then on active node.

My installation failed with below error.
Error: the cluster resource is not online. Bring analysis service server online before starting upgrading process

Error Message

I have analysis services install on both the instance node.
First the Analysis service was stopped when I got the error, So I started the analysis services and re run the installation but it failed with same error.

Since analysis services are not required I tried to remove the feature but guess we cant add or remove features from 2012 cluster environment.

So, Basically I am stuck here and dont know how to proceed with the installation.

Can anyone please help me out!!

Thanks in advance.

@Learning_DBAdmin Following you lead, i checked for dependencies and found there are no dependencies on analysis services.

enter image description here

Also i dont see analysis service resource in roles tab in failover cluster manager.
enter image description here

Is it posssible that i havent properly configured the analysis services on the server?

Following your previous link i came to know that i need to create SSAS generic resource manually in the failover cluster manager. Can you help me to create SSAS generic resource in failover cluster manager.

Thanks in advance.

Best Answer

Ideally in-place upgrade is not very much recommended as this poses multiple risk and has potential to bring your whole database down. You may perform the same on a different server using existing set-up and replace the old servers with new server(set-up) in your go-live activity.

Having said above, few customers go for this upgrade in order to save licensing and servers. From the error message, its very clear that MSSQL service is having dependency on SSAS. Please refer the below screenshot of dependency tab:

No Dependency:

SSAS with No Dependency

With Dependency:

  1. Service depends on other service:

[Dependency 1[2]

  1. Other service depends on this service:

Dependency 2

Based on terminology, I hope its clear that what service depends on other service.

This error would have been logged in either summary or detail log as described here at Mr. Pinal Dave's article:

https://blog.sqlauthority.com/2017/06/20/sql-server-upgrade-failure-cluster-resource-not-online-bring-analysis-services-server-online-starting-upgrade-process/

This also suggests that there was something wrong with the installation, meaning same set of SQL components are not available on active and passive nodes.

As you have already confirmed from the comments that it has worked, you may find details about dependencies above.

I hope above helps.

Related Question