Link to home
Start Free TrialLog in
Avatar of rwheeler23
rwheeler23Flag for United States of America

asked on

SSRS 2005 Move Server

Last month I moved our SSRS databases to a new server and everything appeared fine. Today, I finally took the orignal SQL server off line and much to my surprise SSRS no longer functions. When I fire up the old server, which has now had SQL removed, and I go into SSRS Configuration it is pointing to the old server and if I click find it will only find the instance that used to exist on it. Is there any way I can get the SSRS to allow me to browse to the new server? IIS does not exist on the new server only on the SSRS server. I simply want the SSRS server to point to the new SQL server. The original configuration had SSRS on one server and the databases on another server. All that has changed is that the databases have been moved to another server.
Avatar of dbaSQL
dbaSQL
Flag of United States of America image

This is a very good read on how to migrate the report server databases to another SQL Server:
http://msdn.microsoft.com/en-us/library/ms156421.aspx

Be sure to see this section about 3/4 down:  How to Configure the Report Server Database Connection
It will tell you how to get your SSRS configuration to connect to the new server.
Avatar of rwheeler23

ASKER

That is the part I wish it would let me do. When I go into SSRS Configuration manager it is stuck on the old server name and since the old server no longer exists it will not allow me to change it. All I want it to do is to look at the new server to where the SSRS databases were moved.
ASKER CERTIFIED SOLUTION
Avatar of dbaSQL
dbaSQL
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I gave up and uninstalled SSRS and reinstalled. For some reason it was locked on the old SQL server name for the instance name. After reinstalling it now sees MSSQLSERVER as the instance name. The problem I have now is after completing all configuration steps the Initialization step is dim and not checked. This is SSRS 2005 Standard so it should be dim but I do not see any way to get it to be checked. All the other configuration steps completed successfully. Also, there is no encryption key being used on the SQL server contianing the reports database. Any suggestions on what I can do from here?
It's a lot of detail, but very relevant to the dim/unchecked box.  Please take a look:
http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/52a118e4-9483-45b1-8a3c-ffcebaa261f8/