Share via

Upgrade/Migration SSRS 2014 to 2019 with DB on Remote SQL Server already running SQL 2019

Rhonda Richardson Kovanda 0 Reputation points
2023-07-27T15:47:28.93+00:00

We have upgraded all our SQL servers to 2019 except for the Reporting Services (Native Mode) which is still running on SQL 2014. The reporting service's database is on a remote server that has already been upgraded to SQL 2019.

I am looking for guidance on how to upgrade SSRS to 2019 with the remote SQL server database already running on SQL 2019. As SSRS upgrade doesn't support direct upgrade from 2014 to 2019, is there any article or guidance available to follow for a case where the database is already upgraded to 2019?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,670 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,913 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AniyaTang-MSFT 12,441 Reputation points Microsoft Vendor
    2023-07-28T01:49:45.9066667+00:00

    Hi @Rhonda Richardson Kovanda

    To upgrade from Reporting Services 2016 and earlier to Reporting Services 2017 and later, you need to migrate your Reporting Services installation. You can refer to this document: https://learn.microsoft.com/en-us/sql/reporting-services/install-windows/migrate-a-reporting-services-installation-native-mode?view=sql-server-ver16.

    I also found this link: https://www.sqlservercentral.com/articles/migrating-sql-server-reporting-services, maybe you can use it as a reference.

    Best regards,

    Aniya

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.