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.
LVL 1
rwheeler23Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
dbaSQLCommented:
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.