Ago 01

ReportingServicesTempDB

Tag: Systems — Joaquim Anguas @ 2:54 pm

If you deploy a report and when you try to open it on Report Manager you get:

An internal error occurred on the report server. See the error log for more details.(rsInternalError)
Invalid object name ‘ReportServerTempDB.dbo.PersistedStream'»

You open SQL Server Management Studio and… the database is not there!. You do not give credit and issue:

USE ReportServerTempDB;”

And you get:

Could not locate entry in sysdatabases for database ‘ReportServerTempDB’. No entry found with that name.»

You look at the /Data directory and the files are there…

Then this may help you:

  • Get everyone else out of the server
  • Stop all SQL Server related services
  • Take ownership of the files for the database and move them to a subfolder
  • Start all SQL Server services
  • Create a new database named ReportServerTempDB
  • De-attach & drop it
  • Move the files you previously moved to the subfolder to the original location
  • Attach the database using these files
  • Restart IIS (iisreset)
  • Voilà! It works.