LevelBlue Completes Acquisition of Cybereason.  Learn More

LevelBlue Completes Acquisition of Cybereason.  Learn More

Services
Cyber Advisory
Managed Cloud Security
Data Security
Managed Detection & Response
Email Security
Managed Network Infrastructure Security
Exposure Management
Security Operations Platforms
Incident Readiness & Response
SpiderLabs Threat Intelligence
View All Services
Solutions
BY INDUSTRY
BY REGULATION
BY TOPIC
Offensive Security
Solutions to maximize your security ROI
Operational Technology
End-to-end OT security
Microsoft Security
Unlock the full power of Microsoft Security
Securing the IoT Landscape
Test, monitor and secure network objects
Why LevelBlue
About Us
We reduce cyber risk and fortify organizations
Awards and Accolades
Recognition by analysts and media outlets
LevelBlue SpiderLabs
Global researchers, ethical hackers, and responders
LevelBlue Security Operations Platforms
Unprecedented security visibility and control
Security Colony
Access to cybersecurity threat protection resources
Partners
Microsoft Security
Unlock the full power of Microsoft Security
Technology Alliance Partners
Key alliances who align and support our ecosystem of security offerings
Register
Login
Resources
BLOGS
UPCOMING
MEDIA & ASSETS
NOTICES
HELP
Loading...
Loading...

LevelBlue Knowledge Base

Home » Knowledgebase » Marshal Reporting Console » HOWTO: Upgrading SQL Reporting Services to SQL 2022

HOWTO: Upgrading SQL Reporting Services to SQL 2022

Expand / Collapse
Show/Hide Article Tools


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.

  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:

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.

To contact Trustwave about this article or to request support:

Rate this Article:
     

Add Your Comments


Comment submission is disabled for anonymous users.
Please send feedback to Trustwave Technical Support or the Webmaster.


Execution: 0.031. 9 queries. Compression Disabled.
Powered by InstantKB.NET