Downgrade Enterprise to Standard

Dimitri Stamatiadis 1 Reputation point
2022-02-09T16:38:10.34+00:00

I need assistance with downgrading SSRS from 2019 Enterprise to 2017 Standard. I have an installation that was using 2019 Evaluation although we are using SQL 2017 Standard and the Evaluation has expired. I am now trying to downgrade it to our licensed version. I have tried reinstalling but then it says it cannot validate the integrity of the encrypted data in the database. I have the original backup of the databases before the uninstallation. I have also tried replacing the InstallationID in the Keys table with the ID in the rs config, still no luck. I have now tried to reinstall 2019 Evaluation just to get it running again and start from the beginning but still getting the same error. Please assist

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,682 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,797 questions
0 comments

7 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 40,736 Reputation points
    2022-02-11T07:26:57.833+00:00

    Database downgrade detected. The database schema version is newer than service schema version"

    As Tom already wrote, downgrades are not supported.
    You have to uninstall SSRS, drop ReportServer databases and re-install everything from scratch.

    0 comments
  2. Dimitri Stamatiadis 1 Reputation point
    2022-02-11T09:14:47.127+00:00

    Yes but what about the data? Will I have to discard that and re-create reports subscriptions etc? I have tried re-installing the correct version but then I get either an integrity error or scale out deployment error after logging in to SSRS

    0 comments