Upgrade SQL 2014 Including Availability Group To SQL 2016
As Windows Server 2016 Is coming out shortly I thought I would proceed to upgrade my SQL 2014 Availability Group Cluster to SQL 2016. This is a relatively simple upgrade to complete, however I did encounter an error with SQL Management Studio at the end of the installation which I also created a post about here. I do not specialise in SQL so this may not follow the exact best practices but these steps worked correctly in my environment. It may be advised to create a new SQL 2016 cluster instead of upgrading in a production environment.
You will need to initially login to your current primary instance in your SQL 2014 Availability Cluster. This can be found out using the SQL Availability Group Dashboard. You can find this by expanding the AlwaysOn High Availability section when you are logged in to one of the SQL servers in the cluster.
This is the SQL Availability Group Dashboard. As you can see I’m currently logged in to the Primary and Secondary Node.
Before proceeding to complete the upgrade, you will need to Fail Over the databases to make sure the SQL Server you are upgrading is not the primary instance. You will need to right click the Availability Group (JACOB-AAG01 In this case) and select ‘Failover’. You will now need to select the new primary replica as per below –
You will need to make sure you are using the correct account to login to the server instance, when this has been confirmed you will need to select Connect.
You will be provided with a summary as below –
When you press Finish it will complete the Failover.
We can now proceed to insert the installation media and start the SQL Server Installation Center. The ISO can be found here. You will now need to select the Installation Tab and select Upgrade from a previous version of SQL Server.
You will need to insert your product key and accept the license terms, the installer will then proceed to verify the requirements for the installation of SQL 2016. As you can see this server required a reboot before starting the installation. I completed the reboot and proceeded with the installation.
When the SQL Setup Files have been installed it will verify the upgrade rules. As you can see I already had all of the prerequisites.
You will now need to select the Instance If you have multiple instances on your SQL Servers.
The installer will confirm the features that it will be upgrading in the installation.
You can leave this as default or change the Instance ID.
The installation will now verify the feature rules.
You can now upgrade the installation If the feature rules passed successfully.
When completed you will be presented with the following confirmation.
It is recommended to also install the latest SQL Server Management Studio. This can be found here.
After this was completed I encountered the following error – “Visual Studio License: Prerelease software this license has expired”. I have detailed how this was resolved here.
You will now need to repeat these steps for the secondary node. When this is completed you can verify this has completed successfully by logging in and navigating back to the SQL Availability Group Dashboard. As you can see in my environment this was successful. You may need to resume data movement on the databases If they have stalled, this can be completed by right clicking the Database in the AlwaysOn High Availability Group’s and Selecting ‘Resume Data Movement’. It may also be worth trying to Failover the Databases to confirm this is also still working correctly. Make sure you also test your applications to make sure they are working correctly! Thanks for reading!