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.
rwheeler23Asked:
Who is Participating?
 
dbaSQLConnect With a Mentor Commented:
0
 
dbaSQLCommented:
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.
0
 
rwheeler23Author Commented:
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.
0
 
rwheeler23Author Commented:
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?
0
 
dbaSQLCommented:
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/
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.