Archive for the ‘SSRS’ Category

SSRS Reports Issue after Migration: Invalid object name ‘ReportServerTempDB.dbo.TempCatalog’   4 comments

I recently migrated one of our SQL Server Database Engine and SSRS instances from SQL Server 2008 to SQL Server 2014. Post migration, when I tried to browse the SSRS reports, I get this error:

An error occurred within the report server database.  
This may be due to a connection failure, timeout or low disk condition within the database
. ---> System.Data.SqlClient.SqlException: 
Invalid object name 'ReportServerTempDB.dbo.TempCatalog'.
Could not use view or function 'ExtendedCatalog' because of binding errors.

Read the rest of this entry »