Share via

Error "Invalid object name 'ExtendedCatalog" after migrate SQL reporting services DB from 2012 to 2019

Chong 871 Reputation points
2023-08-18T02:16:38.84+00:00

Hi,

I have backup the ReportServer database and encryption key from a SQL2012 sp4 and restore it to SQL 2019. After reconfigured the reporting services, it shows error "Invalid object name 'ExtendedCatalog" when I run the reporting services:

User's image

I tried to recreate the ReportServerTempDB but the problem still occurs. Any suggestion?

Thanks

Chong

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,061 questions
0 comments
Accepted answer
  1. Anonymous
    2023-08-21T01:37:19.5433333+00:00

    Hi @Chong

    Did you move the database reportserver and the database reportservertempdb together? They are interdependent and must move together.

    For mobile report server database, 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#bkmk_move_database.

    Best regards,

    Aniya

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

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.