The following article has NOT been transferred to Service Cloud. Reason : SDT Upgrade process being reviewed
Urgent note
Do not perform in-place SQL Server upgrades from SQL Server 2012/2014 to 2017 or 2019. Microsoft has removed the option for SQL Server Reporting Services (SSRS) and will uninstall this during an in-place upgrade. SSRS will need to be installed from scratch and may not be able to recover any custom reports.
...
- SQL Server 2012 → SQL Server 2016
- SQL Server 2014 → SQL Server 2016
- SQL Server 2017 → 2017 → SQL Server 2019**
Supported SQL Server versions
- SQL Server 2016 (supported)
- SQL Server 2017 (not recommended for in-place upgrades)
- SQL Server 2019 (supported - but only from SQL Server 2017)
- SQL Server 2017/2019 support requires SQL 2016 database compatibility level
- SQL Server 2022 is not yet supported
SQL Server versions 2017+ have removed SQL Server Reporting Services from the main installer and are not suitable for in-place upgrades. If upgrading to SQL Server 2017 or SQL 2019 is required, a server migration to new machines will need to take place and recommend contacting our Systems team to provide an assessment and quote.
...