SSRS: After migrating to another server
Posted on 2014-03-04
I migrated SQL Reporting Services 2008 R2 to another 2008 R2 server. I'm able to open Report Manager successfully but am getting various errors that reference the "old" server's ReportServerTemp database.
Is there a way of updating all objects in the "new" server's ReportServer and ReportServerTemp databases to reference the new databases?
Specifically, I'm getting an "Invalid object name" error on a table in the ReportServerTemp database. I suspect that somewhere there is still a reference to the old server's databases.