September 10, 2010 at 3:48 pm
We were taxed with moving our existing SQL Server instance from one server to a new server. Unfamiliar with SSRS and may have hosed everything. I detached all user databases, which included ReportServer and ReportServerTempDB. None of our databases were in the default drive path (space reasons) on the old server.
Installed SQL Server2005 with SP2 9.00.3080 - attached all user databases without any issues or errors. Next step is to setup the Reporting Services Configuration Manager.
My question, in the Reporting Services Configuration Manager, do we address where the ReportServer and ReportServerTempDB databases reside or ...
Any assistance is greatly appreciated.
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
September 14, 2010 at 2:56 pm
You should be able to just identify where the report server database is.
Also, you may need to restore the encryption key from the previous server to the current server.
Russel Loski, MCSE Business Intelligence, Data Platform
September 14, 2010 at 3:56 pm
Use this process to move SSRS to another server, this is by far the best description of the process out there.
http://support.microsoft.com/kb/842425
You MUST have the encryption key from the source SSRS for this to work.
This SSC article is also worth a read:
http://www.sqlservercentral.com/articles/Reporting+Services+(SSRS)/69699/
---------------------------------------------------------------------
September 14, 2010 at 4:30 pm
Absolutely brilliant, thank you both so much. We will attack this first thing in the am
Thank you again,
Chris
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply