Error Migrating Reporting Services

I am migrating our reporting services from 2000 to 2005. I am following the instructions in http://msdn2.microsoft.com/en-us/library/ms143724.aspx. I am currently using the Report Server Configuration tool to restore the encryption key. I click "Restore", point to the backup that I created at the beginning of the process, enter the password, and the process begins. I get a check mark and a message saying "Restoring Encryption Key." The problem is that it never comes back from this. I let it run for over an hour and finally clicked one of the previous steps to abort this. I went back and started it over. Again, it has been running for over an hour. I get no errors; it just does not complete. How do I proceed? Thanks in advance for any assistance.

It sounds like you may have hit a bug in the tool. There is also a command line tool that should work. It is called rskeymgmt.exe and should be in your path.

Select rskeymgmt.exe /? to get all of the options. You will need at least -a -i -f -p and -u -v if not logged in as admin.

|||Thanks greatly. That did the trick.|||

Hi,

I want to migrate from an existing ReportServer 2000 to a new ReportServer 2005. For the new ReportServer I want to backup the encryption Key via rskeymgmt.exe.

My command looks like this:

rskeymgmt.exe -e -f c:\backup.key -p Password

Buy everytime I want to execute the command, I′ll get a very strange error:

Unexpected database error (-2147159548) 0x80040e14

With tracing enabled i am getting the following error:

System.Exception: Unexpected database error (-2147159548) 0x80040e14 > System.Exception: 0
End of inner exception stack trace
at Microsoft.ReportingServices.RSKeyMgmt.RSKeyMgmt.InstanceMain()
at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args, BaseCmdLine instance)

I have full admin rights on the server.

The ReportServer database lies on a different server on which I also have admin rights.

What I am doing wrong?

Best regards,

Peter