Support Portal

Welcome, Guest Login

Support Center

How to Upgrade Microsoft SQL Server Instances on Rehost

Last Updated: Oct 25, 2016 02:33PM PDT

Summary

How to upgrade an instance of Microsoft SQL Server by rehosting the instance to a node that has a newer version of Microsoft SQL Server.

Information

For this example there is a 3 node DxEnterprise cluster (Node1-W2K8R2, Node2-W2K12, Node3-W2K12R2) where a Microsoft SQL Server 2008 R2 instance by the name of INST4 is already installed on Node1-W2K8R2 and Node2-W2K12. The goal is to upgrade INST4 to Microsoft SQL Server 2014 on all 3 nodes, with the only downtime being the time it takes to rehost the instance to another server (less than 1 minute).

NOTE: This example shows an upgrade to Microsoft SQL Server 2014, but the steps are the same when upgrading to Microsoft SQL Server 2012.

Here are the steps:

  1. Install a Microsoft SQL Server 2014 instance onto Node3-W2K12R2 with the name of INST4
  2. Verify the service accounts across all nodes for INST4
    You will notice that the service accounts are different on the newly installed INST4. Using Microsoft SQL Server Configuration Manager you will need to modify the service accounts to match those of the existing (virtualized) INST4. For this example we will be using Built-in Microsoft System and Service accounts.
  3. Run DxAdmin management console (formerly DxConsole or DxEnterprise management console) and connect to a node in the cluster
  4. Add Node3-W2K12R2 to the VHost for INST4, in this case the VHost name is VSQL4
  5. Rehost INST4 from Node1-W2K8R2 to Node3-W2K12R2
  6. INST4 is now upgraded to Microsoft SQL Server 2014

     
    NOTE: Once upgraded, the instance will not be able to rehost to a lesser version of Microsoft SQL Server. You will need to complete the upgrade on the remaining nodes before the instance will be highly available again.
  7. Remove Node1-W2K8R2 and Node2-W2K12 from the VHost
  8. Upgrade INST4 from Microsoft SQL Server 2008 R2 to Microsoft SQL Server 2014 on both nodes
  9. Verify that the service accounts are the same as INST4 that is currently virtualized on Node3-W2K12R2. If they are not the same, use Microsoft SQL Server Configuration Manager to change the service accounts to match INST4 on Node3-W2K12R2.
  10. Add the nodes back to the VHost
  11. Test rehost (if desired)
  12. You have just upgraded INST4 from Microsoft SQL Server 2008 R2 to Microsoft SQL Server 2014 with almost no down time!

Applies to...

  • DxEnterprise 15.0
  • DxEnterprise 15.5
  • DxEnterprise 16.0
  • Microsoft SQL Server

Contact Us

support.desk@dh2i.com
http://assets3.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete