How to upgrade SQL Server 2016 to SQL Server 2017

Reading Time: 4 minutes

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

, How to upgrade SQL Server 2016 to SQL Server 2017

, How to upgrade SQL Server 2016 to SQL Server 2017

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

, How to upgrade SQL Server 2016 to SQL Server 2017

  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)

, How to upgrade SQL Server 2016 to SQL Server 2017

  1. On the left pane, select the Installation tab

, How to upgrade SQL Server 2016 to SQL Server 2017

  1. Then choose upgrade from previous version of SQL Server

, How to upgrade SQL Server 2016 to SQL Server 2017

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

, How to upgrade SQL Server 2016 to SQL Server 2017

  1. Accept the Licence Terms, and click next

, How to upgrade SQL Server 2016 to SQL Server 2017

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

, How to upgrade SQL Server 2016 to SQL Server 2017

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

Here “SQL 2016” was chosen.

, How to upgrade SQL Server 2016 to SQL Server 2017

  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

, How to upgrade SQL Server 2016 to SQL Server 2017

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

, How to upgrade SQL Server 2016 to SQL Server 2017

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

, How to upgrade SQL Server 2016 to SQL Server 2017

  1. Next you configure your instance

, How to upgrade SQL Server 2016 to SQL Server 2017

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

, How to upgrade SQL Server 2016 to SQL Server 2017

  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

, How to upgrade SQL Server 2016 to SQL Server 2017

  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

, How to upgrade SQL Server 2016 to SQL Server 2017

  1. Here is the install in progress

, How to upgrade SQL Server 2016 to SQL Server 2017

  1. Once Completed you are presented with this

, How to upgrade SQL Server 2016 to SQL Server 2017

  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

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *