Sample Header Ad - 728x90

SSRS Scale-Out Deployment: cannot decrypt the symmetric key

3 votes
1 answer
625 views
I have a single 2008 ssrs instance (#1) up and running and need to add a 2nd server also running ssrs 2008 (#2). The error message on the 2nd server is: > The report server cannot decrypt the symmetric key that is used to > access sensitive or encrypted data in a report server database. You > must either restore a backup key or delete all encrypted content. Searching on that error, I find plenty of links and posts about backing up and restoring keys, but that seems to move the problem from server #2 to server #1. Server #2 will start working, but #1 will get the same error. I found this regarding rskeymgmt.exe , but that seems to have no impact. The rskeymvmt command reports 'success', but even after restarting both instances of ssrs on each machine, nothing changes. I have also attempted to follow these steps , but my #2 instance never shows up in the scale-out deployment tab in the configuration manager. Any suggestions?
Asked by Roger (133 rep)
Jun 27, 2016, 04:11 PM
Last activity: Aug 25, 2016, 04:01 PM