Moving ReportServer Databases

Followed the steps in Books Online to move the Reporting Services databases from one server to another. After resetting all the keys and configurations, the site comes up. However, all my shared datasources have lost their connection strings, and have reverted to requesting login information. Is this how it is supposed to work? If not, how do I fix this easily (as I have about 25 data sources)?

Hello,

Did you happen to backup the encryption key from your old reporting services instance?

Jarret

|||Nope. Didn't see that part until it was too late.
|||

In Books Online, it says...

After you move the report server database, you must reconfigure the connection information, which is stored as an encrypted value in the rsreportserver.confg file.

Here's a link that describes how to do this. http://support.microsoft.com/Default.aspx?id=842425

Hope this helps.

Jarret

|||

Sorry, but you're going to have to go back and set them up the way they were.

Jarret