Home Forums SQL Server 2005 Business Intelligence renamed ReportServerTEMPDB now errors referencing dbo.executioncache RE: renamed ReportServerTEMPDB now errors referencing dbo.executioncache

  • OK, I found this:

    http://www.sqlservercentral.com/Forums/Topic553765-147-1.aspx

    which includes this:

    "Renaming a report server database is not supported because the report server databases are considered internal components. Renaming the report server databases causes errors to occur. Specifically, if you rename the primary database, an error message explains that the database names are out of sync. If you rename the ReportServerTempdb database, the following internal error occurs later when you run reports:

    "An internal error occurred on the report server. See the error log for more details. (rsInternalError)

    Invalid object name 'ReportServerTempDB.dbo.PersistedStream'."

    This error occurs because the ReportServerTempdb name is stored internally and used by stored procedures to perform internal operations. Renaming the temporary database will prevent the stored procedures from working properly. "

    But, WHAT AM I SPPOSED TO DO? I can't upgrade cleanly because of the name I originally chose for my chose DB and I can't rename it either?

    Has anyone else faced this issue? What did you do? I'm pretty late in this game on the upgrade, certainly there's some experience out there on this.