a predecessor made a mess of a previous SSRS upgrade to SQL 2016 and we’re stuck with the database named as ReportServer_New (and ReportServer_NewTempDB). My Manager has asked if it can be renamed to ReportServer (and ReportServerTempDB) as it should have been
I took a backup of the databases, restored them to the same instance and repointed SSRS to these databases using the SSRS Configuration Manager, including restoring the encryption key.
I can navigate the reports and list parameters get populated from their database but the reports won’t render. I get an “Internal Error” which isn’t very helpful.
Why hasn’t a backup of the database brought it back to life? What have I forgotten?
Can anybody suggest where I should start looking to make it work properly?
Any help gratefully received!
Many thanks
Paul J
user25085708 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.