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
Last activity: Aug 25, 2016, 04:01 PM