Trustwave Becomes First Pure-Play MDR Provider to Attain FedRAMP Authorization. Learn More

Request a Demo
Trustwave Becomes First Pure-Play MDR Provider to Attain FedRAMP Authorization. Learn More

Request a Demo
Services
Managed Detection & Response

Eliminate active threats with 24/7 threat detection, investigation, and response.

Co-Managed SOC (SIEM)

Maximize your SIEM investment, stop alert fatigue, and enhance your team with hybrid security operations support.

Advisory & Diagnostics

Advance your cybersecurity program and get expert guidance where you need it most.

Penetration Testing

Test your physical locations and IT infrastructure to shore up weaknesses before exploitation.

Database Security

Prevent unauthorized access and exceed compliance requirements.

Email Security

Stop email threats others miss and secure your organization against the #1 ransomware attack vector.

Digital Forensics & Incident Response

Prepare for the inevitable with 24/7 global breach response in-region and available on-site.

Firewall & Technology Management

Mitigate risk of a cyberattack with 24/7 incident and health monitoring and the latest threat intelligence.

View All Trustwave Services
Solutions
BY INDUSTRY
BY REGULATION
BY TOPIC
Microsoft Security
Unlock the full power of Microsoft Security
Offensive Security
Solutions to maximize your security ROI
Rapidly Secure New Environments
Security for rapid response situations
Securing the Cloud
Safely navigate and stay protected
Securing the IoT Landscape
Test, monitor and secure network objects
Why Trustwave
About Us
We reduce cyber risk and fortify organizations
Awards and Accolades
Recognition by analysts and media outlets
Trustwave SpiderLabs Team
Global researchers, ethical hackers, and responders
Trustwave Fusion Security Operations Platform
Unprecedented security visibility and control
Trustwave Security Colony
Access to cybersecurity threat protection resources
Partners
Microsoft Security
Unlock the full power of Microsoft Security
Trustwave PartnerOne Program
Join forces with Trustwave to protect against the most advance cybersecurity threats
Register
Login
Resources
BLOGS
UPCOMING
MEDIA & ASSETS
NOTICES
HELP
Loading...
Loading...

Trustwave 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