Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have migrated SQL server 2005 database to sql server 2008 using side by side upgrade. I have copied Reportserver and reportservertempdb database across and configured SQl server Reporting services 2008 to use this new database. I am not able to restore SSRS key over to new SSRS 2008 server. The key restore reports:

Microsoft.ReportingServices.WmiProvider.WMIProviderException: An error occurred when attempting to connect to the report server remote procedure call (RPC) end point. Verify that the Report Server Windows service is running, and then retry the operation.

 ---> System.Runtime.InteropServices.COMException (0x800706B3): The RPC server is not listening. (Exception from HRESULT: 0x800706B3)
   --- End of inner exception stack trace ---
   at Microsoft.ReportingServices.WmiProvider.RSWmiAdmin.ThrowOnError(ManagementBaseObject mo)
   at Microsoft.ReportingServices.WmiProvider.RSWmiAdmin.RestoreEncryptionKey(Byte[] encryptedBytes, String password)
   at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.RestoreEncryptionKey(Byte[] encryptedBytes, String password)

I can open SSRS website but just not the encrypted content because of failure in restoring SSRS key.

Can anyone help please?

share|improve this question

2 Answers 2

Late reply, but I just ran into this issue with moving SSRS 2008 R2 to a new server.

Had the same problem as described above, but going through the Database and Credentials wizards fixed it for me, even though I made no changes and everything was displayed correctly.

Go to Database -> Change Credentials/Change Database in the configuration manager and click through both wizards.

After that I was able to restore the keys.

share|improve this answer
    
This worked for me too, very bizarre. –  rohancragg Oct 11 '13 at 11:37

What error do you get in Reporting Services Configuration Manager when you try and restore the encryption key through there?

share|improve this answer
    
I only know one way to restore the encryption key that is using Reporting Services configuration manager which I have posted above. Microsoft.ReportingServices.WmiProvider.WMIProviderException: An error occurred when attempting to connect to the report server remote procedure call (RPC) end point. Verify that the Report Server Windows service is running, and then retry the operation. –  Manjot Sep 14 '10 at 20:35
    
You can also restore keys from the command line with the RSKEYMGMT utility. The syntax is: rskeymgmt -a -f a:\backupkey\keys -p <password>. I would give this a try and see if you get the same error. Link to MS regarding this utility: msdn.microsoft.com/en-us/library/ms162822.aspx –  SQL3D Sep 21 '10 at 17:29

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.