Trusted Tech Team Blog

Upgrading from a Previous Version of SQL Server

Last updated on May 31st, 2019

Need to upgrade from a previous version of SQL Server? (I.e 2014-2016 Standard or 2016-2017 Standard)

Follow this guide, and you’ll be on the latest version in no time.

If you need to upgrade your edition of SQL follow this guide instead.

Click Here to see a list of supported version and edition upgrades!

How to Upgrade

This process will work with versions of SQL starting at 2008.

1) First, open up the Installation Center of the target edition and navigate to the Installation tab. Click on “Upgrade from a previous version of SQL Server”
(in this example, we are upgrading from SQL 2016 > 2017).

2) After the installer runs its initial checks, you’ll see the option to install either the evaluation version or enter your product key (your open license installer will automatically input your key here).

3) Read thoroughly through the license terms and accept the terms when you’re ready to proceed.

4) You can opt in for automatic updates on this step. As always, this is recommended.

5) Select the instance that you want to upgrade from the dropdown menu. Click next when you’re ready.

6) Choose additional features to upgrade (these are typically automatically selected for you).

7) Double check the name and instance ID for your server. Click next when you’re ready.

8) We’re now ready to upgrade! Go ahead and double-check everything one more time, and click ‘Upgrade’ (this should take about 5-10 minutes to complete).

9) Congratulations! You have successfully upgraded your SQL version. You may need to restart the Server for the changes to finalize.

Leave a Comment