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.
- Install SQL 2016 Service Pack 3 for the MRC_SQLEXPRESS instance. A computer restart will be required after installation.
- 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.
- Install Microsoft SQL Server 2022 Reporting Services.
- Choose the free edition Express.
- On the Setup Complete screen, click Configure report server.
- 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.
- 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:
In some cases (where a current release of MailMarshal Array Manager is installed on the same server), the installation of SQL 2022 may report an error on installation of MSOLEDBSQL.
- You can safely ignore this error and continue. MailMarshal has already installed a compatible version of MSOLDDBSQL.
- If the error appears in the rules check and you cannot continue:
- Stop the MailMarshal Array Manager.
- Uninstall the offending version of MSOLEDBSQL.
- Upgrade SQL
- Re-install the version of MSOLEDBSQL. All versions are available for download from Microsoft.
- Start the Array Manager.