Upgrading SQL Server 2014 to 2019 but retaining reporting services

John D 26 Reputation points
2022-05-26T12:22:48.21+00:00

Hello,

I have a SQL server with 2x SQL server 2014 instances. One of these instances has an SSRS (Native) install and I want to upgrade both instances (In Place) to SQL server 2019. I know that upgrade of the SSRS element is not possible in this scenario (2014 > 2019)

My question is if I did the upgrade to SQL server 2019 on the instance with SSRS, would the SSRS 2014 installation still function? Is this scenario possible?

Thanks for any reply.

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,485 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,772 questions
0 comments No comments
{count} votes

Accepted answer
  1. Bjoern Peters 8,776 Reputation points
    2022-05-26T13:00:49.507+00:00

    I would think that the answer might be "yes, it will continue to work," but I can't promise.

    Another way to try can be:
    1.) Inplace Upgrade of that instance without SSRS

    2.) Install a third instance with 2019 - migrate everything from the SSRS instance
    3.) Uninstall all of the remaining unnecessary 2014 features/services


1 additional answer

Sort by: Most helpful
  1. Isabellaz-1451 3,611 Reputation points
    2022-05-27T02:02:05.337+00:00

    Hi @John D

    Generally speaking, it's okay for SSRSto have a lower version number than SQL server, but since SSRS has been separated from SQL server since version 2017, I don't know if this is compatible, but I think it should be compatible. you can upgrade SQL server first , then see if SSRS 2014 can work normally, if it works well,then don‘t need to upgrade the SSRS. if not, upgrade SSRS to SSRS2017 or SSRS 2019.

    Here is official document about how to upgrade the SSRS ,you can take a reference:https://learn.microsoft.com/en-us/sql/reporting-services/install-windows/upgrade-and-migrate-reporting-services?view=sql-server-ver16

    Upgrade to Reporting Services 2017 and later from Reporting Services 2016 and older isn’t the same upgrade scenario as in previous versions. When upgrading to Reporting Services 2016 and older versions, you could following an in-place upgrade process using SQL Server installation media. When upgrading to Reporting Services 2017 and later from Reporting Services 2016 and older, you can’t follow the same steps because the new Reporting Services installation is a standalone product. It's no longer part of the SQL Server installation media.

    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.

    Best Regards,
    Isabella


    If the answer is the right solution, please click "Accept Answer" and upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.