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.
- Download the SQL server 2017 Media from Microsoft
- https://www.microsoft.com/en-gb/sql-server/sql-server-downloads
- 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
![](http://www.turbogeek.co.uk/wp-content/uploads/2019/07/word-image.png)
![](http://www.turbogeek.co.uk/wp-content/uploads/2019/07/word-image-1.png)
- 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.
![](http://www.turbogeek.co.uk/wp-content/uploads/2019/07/word-image-2.png)
- 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)
![](http://www.turbogeek.co.uk/wp-content/uploads/2019/07/word-image-3.png)
- On the left pane, select the Installation tab
![](http://www.turbogeek.co.uk/wp-content/uploads/2019/07/word-image-4.png)
- Then choose an upgrade from the previous version of the SQL Server
![](http://www.turbogeek.co.uk/wp-content/uploads/2019/07/word-image-5.png)
- Next enter your licence details. Choose “Developer” to install “free edition.
![](http://www.turbogeek.co.uk/wp-content/uploads/2019/07/word-image-6.png)
- Accept the Licence Terms, and click next
![](http://www.turbogeek.co.uk/wp-content/uploads/2019/07/word-image-7.png)
- Next, the setup will install the necessary pre-setup files. This is an automated process.
![](http://www.turbogeek.co.uk/wp-content/uploads/2019/07/word-image-8.png)
- Once complete, you will be asked which select instance to upgrade
Here “SQL 2016” was chosen.
![](http://www.turbogeek.co.uk/wp-content/uploads/2019/07/word-image-9.png)
- 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
![](http://www.turbogeek.co.uk/wp-content/uploads/2019/07/word-image-10.png)
- Next chose the features to upgrade. These are greyed out as we are upgrading the entire instance in this example.
![](http://www.turbogeek.co.uk/wp-content/uploads/2019/07/word-image-11.png)
- You will then be asked to consent to Microsoft R open – click accept and next
![](http://www.turbogeek.co.uk/wp-content/uploads/2019/07/word-image-12.png)
- Next you configure your instance
![](http://www.turbogeek.co.uk/wp-content/uploads/2019/07/word-image-13.png)
- Confirm your user accounts, add or remove if required.
![](http://www.turbogeek.co.uk/wp-content/uploads/2019/07/word-image-14.png)
- 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
![](http://www.turbogeek.co.uk/wp-content/uploads/2019/07/word-image-15.png)
- 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
![](http://www.turbogeek.co.uk/wp-content/uploads/2019/07/word-image-16.png)
- Here is the install in progress
![](http://www.turbogeek.co.uk/wp-content/uploads/2019/07/word-image-17.png)
- Once Completed you are presented with this
![](http://www.turbogeek.co.uk/wp-content/uploads/2019/07/word-image-18.png)
- 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
Recent Comments