Is it possible to do an In-Place upgrade from SSRS 2016 to 2019 ?

AdamMohamed-3032 56 Reputation points
2023-11-01T17:23:25.44+00:00

Hello All,

Could someone please check and confirm that - Is it possible to do an In-Place upgrade for SSRS from 2016 to 2019 ?

Note : We are using SCOM 2019 with UR4.

Regards,

Adam

Operations Manager
Operations Manager
A family of System Center products that provide infrastructure monitoring, help ensure the predictable performance and availability of vital applications, and offer comprehensive monitoring for datacenters and cloud, both private and public.
1,417 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. XinGuo-MSFT 14,461 Reputation points
    2023-11-02T08:03:48.9533333+00:00

    Hi,

    Unfortunately, the official does not support In-Place upgrading SSRS from 2016 to 2019, We can upgrade SSRS through migration.

    https://learn.microsoft.com/en-us/sql/reporting-services/install-windows/upgrade-and-migrate-reporting-services?view=sql-server-ver16#bkmk_inplace_upgrade

    User's image

    To upgrade from Reporting Services 2016 and older versions to Reporting Services 2017 and later, follow the Migrate a Reporting Services Installation (Native Mode) article, with Reporting Services 2017 or later as your destination instance.

  2. SChalakov 10,261 Reputation points MVP
    2023-11-22T15:13:57.1+00:00

    Hi Adam,

    may I suggest something: If you have saved or scheduled reports it makes sense to seek a migration. But if you don't have those (like most customers), why just not do a new install? Its easier, quicker and cleaner.

    SSRS installs the Report DB and the Reortt Temp DB, those actually do not contain any data besides what you jave saved (favourite reports, scheduled reports, custom reports, etc...). The actual data is in the Data Warehouse.

    So, if you don't have any of the above mentioned report types, just uninstall the old version, install the version you need and all the standard reports will be populated again.

    I hope I could help you out!

    (If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)
    Regards
    Stoyan Chalakov