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.
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).
Here are the steps:
- Install a Microsoft SQL Server 2014 instance onto Node3-W2K12R2 with the name of INST4
- 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.
- Run DxAdmin management console (formerly DxConsole or DxEnterprise management console) and connect to a node in the cluster
- Add Node3-W2K12R2 to the VHost for INST4, in this case the VHost name is VSQL4
- Rehost INST4 from Node1-W2K8R2 to Node3-W2K12R2
- 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.
- Remove Node1-W2K8R2 and Node2-W2K12 from the VHost
- Upgrade INST4 from Microsoft SQL Server 2008 R2 to Microsoft SQL Server 2014 on both nodes
- 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.
- Add the nodes back to the VHost
- Test rehost (if desired)
- You have just upgraded INST4 from Microsoft SQL Server 2008 R2 to Microsoft SQL Server 2014 with almost no down time!
- DxEnterprise 15.0
- DxEnterprise 15.5
- DxEnterprise 16.0
- Microsoft SQL Server