Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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.

share|improve this question

2 Answers 2

Per Microsoft, Renaming the report server database is not supported.

http://msdn.microsoft.com/en-us/library/ms159093.aspx

share|improve this answer

Use the Reporting Services Configuration tool to direct SSRS to a different database.

Did you just copy the SSRS 2005 database and are now pointing 2008 at it? I'm not sure what database schema differences there may be between an SSRS 2005 DB and one from SSRS 2008.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.
{"cc_re__cc_re__cc_by_sa_3_0": ["                  <li><a href=\"//area51.stackexchange.com\" title=\"proposing new sites in the Stack Exchange network\">Area 51</a></li>\r\n                        <li><a href=\"//careers.stackoverflow.com\">Stack Overflow Careers</a></li>\r\n                    \r\n                </ol>\r\n            </td>\r\n    </tr>\r\n</table>\r\n                </div>\r\n            </div>\r\n\r\n            <div id=\"copyright\">\r\n                site design / logo &#169; 2015 stack exchange inc; user contributions licensed under <a href=\"http://creativecommons.org/licenses/by-sa/3.0/\" rel=\"license\">cc by-sa 3.0</a> \r\n                with <a href=\"http://blog.stackoverflow.com/2009/06/attribution-required/\" rel=\"license\">attribution required</a>\r\n            </div>\r\n            <div id=\"svnrev\">\r\n                rev 2015.3.26.2411\r\n            </div>\r\n            \r\n        </div>\r\n    </div>\r\n    <noscript>\r\n        <div id=\"noscript-warning\">Server Fault works best with JavaScript enabled<img src=\"http://pixel.quantserve.com/pixel/p-c1rF4kxgLUzNc.gif\" alt=\"\" class=\"dno\"></div>\r\n    </noscr"], "copyright__copyright__copyright": ["is answer\n\nUse the Reporting Services Configuration tool to direct SSRS to a different database.\n\nDid you just copy the SSRS 2005 database and are now pointing 2008 at it? I'm not sure what database schema differences there may be between an SSRS 2005 DB and one from SSRS 2008.\n\nshare|improve this answer\n\nYour Answer\n\n\u00a0\ndiscard\n\nBy posting your answer, you agree to the privacy policy and terms of service.\n\nNot the answer you're looking for? Browse other questions tagged or ask your own question."]}