Is there anyway to rename a SSRS database? I am moving from SSRS 2005 to 2008 but want to fully test before I cut over to the new server.
The plan was to create a copy of the SSRS database and point the 2008 instance at the new DB. That appears to work fine except event tough the configuration UI says I'm connecting to the new DB (and I confirmed with SQL Profiles that there are queries hitting the new DB).
However there are errors in the log file that show that its hitting the old DB and the old TempDB.
Is there anyway to tell SSRS to use the new DB name? I searched in all the config files and I don't see the old DB name anywhere.
Best Answer
Per Microsoft, Renaming the report server database is not supported.
http://msdn.microsoft.com/en-us/library/ms159093.aspx