Prepare SSRS for upgrade to SSRS 2017, 2019 or 2022

In SQL Server 2017, 2019 or 2022, the Reporting Services (SSRS 2017, 2019 or 2022) is a separately installed feature. As part of the preparation, the report server databases and encryption key must be backed up.

Upgrading SQL Server uninstalls the Reporting Services only if the SQL Server and the Reporting Services are on the same machine. If not, it is required to manually uninstall the previous Reporting Services.

Procedure 

1. Back up the report server databases, ReportServer and ReportServerTempDB.

2. Back up the encryption key:

   1. Open Reporting Services Configuration Manager.

   2. Connect to the Report Server Instance.

   3. In the Encryption Keys screen, click Backup.

   4. In the Backup Encryption Key dialog, set the file location and name for the key backup file.

   5. Set a password and note it for later use when restoring the encryption key.

      Make sure you keep the file details and the password. Otherwise, it will not be possible to complete the SSRS configuration.

      

3. If the SQL Server and the Reporting Services are on different machines, manually uninstall the previous Reporting Services.