ssrs 2016 to 2019 ssrs in place upgrade

  • So have existing 2016 SQL instance and SSRS on same box. They need to upgrade ssrs to 2019. I was going to do in place for sql instance first (it has reporting sever db's) and a few others. For the SSRS upgrade do I need to uninstall SSRS (after backing up keys) and then do install of 2019 ssrs and point it to the upgraded sql instance?

  • tcroninlifepoint wrote:

    So have existing 2016 SQL instance and SSRS on same box. They need to upgrade ssrs to 2019. I was going to do in place for sql instance first (it has reporting sever db's) and a few others. For the SSRS upgrade do I need to uninstall SSRS (after backing up keys) and then do install of 2019 ssrs and point it to the upgraded sql instance?

    If you are doing an in-place upgrade, the installation will pick up all of the components of SQL Server, and upgrade them.  If you uninstall SSRS, you will not be upgrading the database.  I suspect that there are changes to the SSRS databases that an upgrade will perform.

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply