Share via

Windows Cluster 2008 R2 upgrade to Windows 2016

sakuraime 2,341 Reputation points
2021-03-28T12:12:53.797+00:00

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
Windows Server Clustering
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Clustering: The grouping of multiple servers in a way that allows them to appear to be a single unit to client computers on a network. Clustering is a means of increasing network capacity, providing live backup in case one of the servers fails, and improving data security.
1,027 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alex Bykovskyi 2,241 Reputation points
    2021-03-28T20:43:16.747+00:00

    Hey,

    According to the documentation, in-place upgrade from 2008r2 to 2016 is not supported.
    https://learn.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.

  2. Xiaowei He 9,936 Reputation points
    2021-04-07T03:33:57.697+00:00

    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.

  3. kumar kaushal 176 Reputation points Microsoft Employee
    2021-04-14T09:57:01.197+00:00

    @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 .

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.