Share via

SQL Reporting Services questions on in place upgrade from 2014 to 2019

Takami Chiro 251 Reputation points
2023-08-31T15:01:24.3533333+00:00

Hi good morning everyone,

Still stuck in the SQL server upgrade project. Our 2014 SQL server has Reporting Services in it. I plan to do a in-place upgrade. I know that the upgrade from 2014 to 2019 will be "forced" to uninstall the reporting services. I have a few questions about this.

1.) I will re-install the reporting services after the 2019 upgrade, If this is the case, do you think the reinstall will get all the original configurations back? Or I still need to restore the config? Also do I need restore the reporting database (I could still see the original them after the upgrade before reinstalling the Reporting services) ?

2.) Is it possible to use Reporting Migration tools in this case?

Thank you for your sharing your info in advance.

Takami Chiro

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

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. AniyaTang-MSFT 12,451 Reputation points Microsoft External Staff
    2023-09-01T01:32:27+00:00

    Hi @Takami Chiro

    For SSRS upgrade issues, you can check this document: Upgrade and Migrate Reporting Services.

    For finding product key for SSRS you can check this link: Find the product key for SQL Server Reporting Services.

    If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

    Best regards,

    Aniya

    0 comments
  2. Takami Chiro 251 Reputation points
    2023-09-01T18:44:55.9066667+00:00

    Hi Aniya,

    Thank you for your response. I am doing an in-place upgrade. Do you think if the original configurations will be retained without any further configurations?

    Thank you again

    Takami Chiro

    0 comments

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.