Two installations of SSRS 2005 on two separate machines in my shop seem to regularly lose their encryption keys at exactly the same time. These are developer machines with the development edition of SQL Server 2005 running, so I'm hoping that perhaps someone here has an explanation for this. About once a month, they lose their encryption keys and display the message:
"The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content."
Restoring the keys from backup fixes the problem. However, it seems odd that they both "lose" the keys at regular intervals. I can even recall at least once instance when it happened on exactly the same day. Does anyone have any ideas why this would be? Here is some information about the installations:
SQL Server Type: SQL Server 2005
Developer Edition Build Number: 3353
Reporting Services Account: Network Service
Thank you...
