|
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:
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:
Thank you...
(comments are locked)
|
|
Based on the frequency it almost sounds like a password change issue with the Network Service. Have you tried rebooting the box or recycling SSRS services to see if the error clears up instead of restoring the backup key? Yes. We turn our development machines off at night, so it gets a fresh start every morning.
Oct 30 '09 at 04:26 PM
NYSystemsAnalyst
Do they lose their keys at start-up or after having been running for awhile?
Oct 30 '09 at 04:50 PM
Blackhawk-17
Are .NET hotfixes applied every month? They can sometimes cause issues.
Oct 30 '09 at 05:01 PM
Blackhawk-17
Yes, they are. However, we never see this problem on our production or test servers which run SQL Server Standard edition. It only seems to happen on machines that run Development edition.
Nov 02 '09 at 10:29 AM
NYSystemsAnalyst
(comments are locked)
|
|
The problem could be caused by changing the 'log on as' account used in the SQL Server Agent Windows service. Additional information found here.
(comments are locked)
|
