question

sakuraime avatar image
0 Votes"
sakuraime asked kumarkaushal-1277 answered

Windows Cluster 2008 R2 upgrade to Windows 2016

I have a SQL server 2012 on Windows Cluster 2008 R2 and need to upgrade . And need to do inplace upgrade.
And I know the node need to evict from the cluster first before upgrade.
After upgrade to Windows 2016 , Failover cluster manager is not able to open .
82080-35.jpg




how to solve it ??

I will need to reinstall the failover cluster on the upgraded server ..


Also how to add back the SQL Server service on to the cluster role ?? Coz I can't see Sql Server in other resources ..

windows-server-clustering
35.jpg (52.8 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AlexBykovskyi avatar image
0 Votes"
AlexBykovskyi answered sakuraime commented

Hey,

According to the documentation, in-place upgrade from 2008r2 to 2016 is not supported.
https://docs.microsoft.com/en-us/windows-server/failover-clustering/upgrade-option-same-hardware

In order to finish the process, it would be better to create a new cluster and migrate existing SQL Server Instances to it. The following guide should help:
https://www.starwindsoftware.com/resource-library/starwind-virtual-san-installing-and-configuring-sql-server-2017-failover-cluster-instance-on-windows-server-2016/

Cheers,

Alex Bykovskyi

StarWind Software

Note: Posts are provided “AS IS” without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

yes. I know that, but due to some limitation , we need to do in place upgrade , 2008 -> 2012 ->2016

so we need to take out the node from cluster first .

and after upgrade the windows , the failover cluster manager can't open . And work around to solve it ?

0 Votes 0 ·
XiaoweiHe-MSFT avatar image
0 Votes"
XiaoweiHe-MSFT answered XiaoweiHe-MSFT commented

Hi,

Please try to re-install the Failover cluster feature, check if it could work.

Besides, please run sfc /scannow to check if there are any corrupted system files.

Thanks for your time!
Best Regards,
Anne


If the Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

yes. I will need to reinstall the failover cluster again . thanks

0 Votes 0 ·

Welcome to feedback if it is resolved after re-installation. :)

0 Votes 0 ·
kumarkaushal-1277 avatar image
0 Votes"
kumarkaushal-1277 answered

@sakuraime .. The feature of Mixed mode cluster came only from 2012 r2 where you can add a 2016 server to a 2012 r2 cluster . And from 2016 to 2019 , you don't need to evict that node . Just pause and upgrade .

So in a nutshell you need to recreate a cluster in earlier version of OS before 2012 r2. I am not sure How SQL can be migrated and if it can be migrated because i don't have expertise on that .

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.