SSRS migration SP 2013 to SP 2019

shashank 131 Reputation points
2021-02-15T08:54:22.283+00:00

We have on-prem SP 2013 environment (with SQL 2012) which is running hundreds of SSRS reports. We are planning to migrate to on-prem SP 2019 (with SQL 2016) and it says SP 2019 doesn't have SSRS feature now. In this case, how do we get to see our existing SSRS reports in SP 2019

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,849 questions
SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,864 questions
0 comments No comments
{count} votes

Accepted answer
  1. KoprowskiT 236 Reputation points
    2021-02-15T18:06:16.447+00:00

    @shashank There are no migration steps for SSRS from SP2013 to SP2019, as SSRS in SP 2019 not exist at all. The way you can use is to migrate to PowerBI, which in most cases mean you have to rewrite reports using PowerBI. Which all you:
    1st - making your report better and more usable to clients
    2nd - reduce the number of reports (as users will be able to drill-in-to existing reports
    3rd - manage distribution (sharing) reports much more effectively than with SSRS

    Links which could help:

    1 person found this answer helpful.

2 additional answers

Sort by: Most helpful
  1. Lukas Yu -MSFT 5,816 Reputation points
    2021-02-15T09:54:54.927+00:00

    Hi,

    Sharepoint integrated SSRS is no more supported with newest release of both apps.

    The newest we could get in SSRS 2016 with SharePoint 2016. I am afraid there is no work around here and we have to go other way.

    You could see the SSRS and SharePoint combination here : Supported combinations

    Regards,
    Lukas


  2. KoprowskiT 236 Reputation points
    2021-02-17T11:24:45.933+00:00

    @shashank well, mate. We explained it very well. Not only once. You have to rebuild every report from scratch. SSRS is finally removed as a feature from SQL Server and SharePoint Server. There is no possibility to have it a- as before - in SharePoint 2019. You have to rebuild it into PowerBI.

    The article you mentioned is not relevant as they explain implementation on SQL Server 2012 and SharePoint 2013. As well there is a lot of errors and bad practices in this article (wrong location, wrong installation, putting together SQL Engine and SSRS in one instance and more). This is an example of the very, very bad practice.

    There are some examples of how you can configure SharePoint 2019 with SSRS 2017 BUT - and this is the citation from the blog post:
    "Officially SSRS Integrated mode is deprecated in SQL Server 2017 and SharePoint 2019, Now It is not a part of the SQL Server 2017. However, organizations could continue to use SSRS versions 2017 in SharePoint 2019. This is not supported in SharePoint 2019, which means that integrated mode isn’t an option at all with SharePoint 2019.
    But the good news is, there is some workaround to integrate SSRS 2017 with SharePoint 2019 using the report viewer web part."

    So if you will go this way, this solution is not supported by Microsoft. Which means - in case of a disaster of problem Microsoft support will not help you, because the solution is not supported.