Share via

How to merge multiple SSRS instance into one new single SSRS instance?

Marcus Wong Theen Nam 1,141 Reputation points
2025-01-12T10:31:02.86+00:00

I'm migrating and consolidating two SQL instances into one new SQL Server 2022 instance. For user databases these are fine as I can just backup and restore them to new instance. But how about the SSRS currently running on both source instance?

Each of them has ReportServerDB and ReportServerTempDB in native mode and has their own encryption key. How do I merge both SSRS instance into one ? I'm not from DBA background hence I do not have any idea on how to merge multiple ReportServerDB into single DB. Hopefully someone could guide me through or provide some steps/insights.

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,280 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,968 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Javier Villegas 900 Reputation points MVP
    2025-01-12T13:50:04.3233333+00:00

    Hi @Marcus Wong Theen Nam

    Unfortunately you cannot install multiple instances of SSRS on the same server . it was possible long time ago but it is not right now.

    I'll suggest you to choose one of the instances and do the restore and then created a folder and redeploy all the other components from the other one

    Regards

    Javier

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.