In-Place Upgrade from SQL Server 2014 to 2016

How to Upgrade SQL 2014 to SQL 2016

1. Mount the SQL 2016 ISO or media on your current SQL 2014 server.
2. Select “Upgrade from a previous version of SQL Server”

SSRS 2016

Part of SQL Server 2016 install.

Select “Reporting Services – Native” from Instance Features

https://social.technet.microsoft.com/wiki/contents/articles/50902.sql-server-2016-install-and-configure-ssrs.aspx

https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/upgrade-and-migrate-reporting-services?view=sql-server-ver15

Notes:

• Backup all databases in case the In-Place Upgrade fails. You will have to uninstall SQL Server 2014 and then re-install SQL Server 2016.
• Decide if you want Standard or Enterprise Edition for Production. Use Developer Edition for Non-Production install. Developer Edition has all the features of Enterprise Edition.
• Make sure you have the license key if this is for Production.
• You must also upgrade SSRS from 2014 to 2016, part of SQL Server install. “Reporting Services – Native” in Instance Features.
• Make sure to backup the SSRS encryption key as well.

Sources:

How to Upgrade SQL Server 2014 to SQL Server 2016