I am trying to move my reporting databases on Server1 to another server (Server2). The databases are named ReportServer$Server1 and ReportServer$Server1TempDB, and I would like them to be named ReportServer$Server2 and ReportServer$Server2TempDB on Server2. I have followed all the steps in the KB articles on moving databases, and I have restored the key from Server1 onto Server2. I can use the Report Manager to change the Data Source connection string on Server2. However, when I try to access a report, or delete an unwanted object, it always errors out, and there is a reference to ReportServer$Server1TempDB in the error message.
Where is this dependency on the old name coming from? Is there no way to rename the report server databases?
Thx
Helen
Further to my question, it appears that changing the name of the report databases when moving them to another server is not supported. I have solved my problem by using the configuration tool to create new report databases on Server1, named ReportServer and ReportServerTempDB. I then rebuilt all my reporting objects, and following the instructions in the various KB articles, successfully moved the 3 databases to Server2 (without changing their names).
If anyone knows how to move report server databases and also change their names, I'd love to know how you did it. Also, if anyone knows where the dependency on the name of the tempdb is (somewhere in the reportserver db) I'd alsp be interested.
Cheers
No comments:
Post a Comment