How to upgrade SQL Server 2016 to SQL Server 2017
Upgrade SQL Server 2016 to SQL Server 2017
author(s) : Richard Bailey
- SQL Server 2017 media (licence if applicable)
- x64 Bit Operating System and if upgrading must have existing 64bit SQL Server instance.
- SQL Server 2017 supports upgrade from the following versions of SQL Server:
- SQL Server 2008 SP4 or later
- SQL Server 2008 R2 SP3 or later
- SQL Server 2012 SP2 or later
- SQL Server 2014 or later
- SQL Server 2016 or later
- Download the SQL server 2017 Media from Microsoft
- Select the “Developer Edition”
- This will download a small download initiator file called SQLServer2017-SSEI-DEV.exe and it will be downloaded to your downloads folder.
- Open the file SQLServer2017-SSEI-DEV.exe and choose DOWNLOAD MEDIA
- This will download the media to your local computer. It may take a while depending on the speed.
- Choose your Language and Select format ISO.
- Choose where you want to download to.
- Once Downloaded you will see the ISO image called SQLServer2017-x64-ENU-Dev.iso
- Double click on the ISO to open the SQL ISO image on your local computer. This will mount the image to your computer as a virtual DVD drive.
- Then run the setup executable (please note it may take several minutes to open)
- On the left pane, select the Installation tab
- Then choose upgrade from previous version of SQL Server
- Next enter your licence details. Choose “Developer” to install “free edition.
- Accept the Licence Terms, and click next
- Next, the setup will install the necessary pre-setup files. This is an automated process.
- Once complete, you will be asked which select instance to upgrade
Here “SQL 2016” was chosen.
- You will get warning about incompatible features. Microsoft discontinue some features in SQL. Here there is a warning about SharePoint Report services. Tick the check box and then next
- Next chose the features to upgrade. These are greyed out as we are upgrading the entire instance in this example.
- You will then be asked to consent to Microsoft R open – click accept and next
- Next you configure your instance
- Confirm your user accounts, add or remove if required.
- Next we run the import of data. For consistency its recommended to import. I only ever recommend rebuild if you are upgrading from significantly older versions of SQL
- Once completed you are now ready to install SQL 2017
- Check for any issues on the screen below and click next
- You are look at about 20 minutes to install
- Here is the install in progress
- Once Completed you are presented with this
- Reboot your server to complete
Check the Event Viewer for any errors
It is highly recommended to run Windows update after the installation of any SQL product