x

Reporting Services Loses Encryption Keys

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...

more ▼

asked Oct 30, 2009 at 12:18 PM in Default

avatar image

NYSystemsAnalyst
312 5 7 10

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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?

more ▼

answered Oct 30, 2009 at 02:54 PM

avatar image

Blackhawk-17
12k 30 35 42

(comments are locked)
10|1200 characters needed characters left

The problem could be caused by changing the 'log on as' account used in the SQL Server Agent Windows service.

Additional information found here.

more ▼

answered Oct 30, 2009 at 07:42 PM

avatar image

littlefuzz
11

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x2017
x660

asked: Oct 30, 2009 at 12:18 PM

Seen: 4897 times

Last Updated: Oct 30, 2009 at 12:18 PM

Copyright 2016 Redgate Software. Privacy Policy