This article applies to:

• Marshal Reporting Console
• SQL Server and SSRS 2022

Question:

• Can I install MRC with SQL 2022?
• Can I upgrade the MRC SQL and SQL Reporting Services instances to SQL 2022?

Procedure:

MRC 2.6 cannot be directly installed with SSRS 2022. However it is possible to upgrade the standalone MRC instances to SQL 2022 and SSRS 2022.

This procedure assumes you have installed MRC using the bundled SQL Express 2016 Advanced installer, and tested operation. For installations using licensed SQL, adjust the selections as required.

• This procedure can also be used for a new installation on Windows 2025 (SQL Express 2016 must be manually installed first - see the notes section below).

1. Install SQL 2016 Service Pack 3 for the MRC_SQLEXPRESS instance.  A computer restart will be required after installation.
   
2. From the Start menu, open Reporting Services Configuration Manager.
   • Note the Report Server Database Name (by default, ReportServer$MRC_SQLEXPRESS). If you have used custom credentials, note the settings.
   • From the Encryption Keys page, back up the key to a file.
   • Exit the Reporting Services Configuration Manager.
3. Install Microsoft SQL Server 2022 Reporting Services.
   • Choose the free edition Express.
     
   • On the Setup Complete screen, click Configure report server.
4. In the Report Server Configuration Manager:
   • On the WebService URL page, click Apply to accept the default values.
   • On the Database page, click Change Database. In the wizard,
     • Select Choose an existing report server database.
     • On the Database Server page, the Server Name is the local computer name with MRC_SQLEXPRESS. Do not choose "Encrypt".
     • On the Database page, select the database you noted in step 2. 
       
     • On the Credentials page, if you have not used the default service credentials, enter the credentials you noted in step 2.
     • Complete the wizard, click Finish, and exit the wizard.
     • On the Encryption Keys page, restore the key from your backup. You will be asked for confirmation to remove other registered servers. Click OK to this question.
     • Exit the Reporting Services Configuration Manager.
5. Upgrade to SQL Server 2022 Express.
   • On the Welcome screen, choose the Custom option.
   • On the Installation Center screen, choose Upgrade.
   • On the Select Instance screen, select MRC_SQLEXPRESS.
     
   • On the Reporting Services Migration screen, check the box Uninstall Reporting Services. 
   • Complete the upgrade process.

Notes: