Upgrade from SQL Server 2016 to 2017

Upgrade SQL Server 2016 to SQL Server 2017

author(s) : Richard Bailey

Pre-Requisites

• 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

Upgrade Process.

1. Download the SQL server 2017 Media from Microsoft
   1. https://www.microsoft.com/en-gb/sql-server/sql-server-downloads
   2. Select the “Developer Edition”
   3. This will download a small download initiator file called SQLServer2017-SSEI-DEV.exe and it will be downloaded to your downloads folder.
   4. 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.

1. Once Downloaded you will see the ISO image called SQLServer2017-x64-ENU-Dev.iso
2. 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.
3. Then run the setup executable (please note it may take several minutes to open)

1. On the left pane, select the Installation tab

1. Then choose an upgrade from the previous version of the SQL Server

1. Next enter your licence details. Choose “Developer” to install “free edition.

1. Accept the Licence Terms, and click next

1. Next, the setup will install the necessary pre-setup files. This is an automated process.

1. Once complete, you will be asked which select instance to upgrade

Here “SQL 2016” was chosen.

1. 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

1. Next chose the features to upgrade. These are greyed out as we are upgrading the entire instance in this example.

1. You will then be asked to consent to Microsoft R open – click accept and next

1. Next you configure your instance

1. Confirm your user accounts, add or remove if required.

1. 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

1. Once completed you are now ready to install SQL 2017
2. Check for any issues on the screen below and click next
3. You are look at about 20 minutes to install

1. Here is the install in progress

1. Once Completed you are presented with this

1. Reboot your server to complete

Post-upgrade tasks

Check the Event Viewer for any errors

It is highly recommended to run Windows update after the installation of any SQL product