February 12, 2009 at 8:50 am
We applied the patch to a development server, but reporting services wouldn't start. The reporting services had been set up a long time ago and ran under the local services account. I finally tried changing from local services to a known system administrator account and the services started. However, if you try to access the reports, you get the following 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. Check the documentation for more information.”. We have the report server key saved, but when we tried to restore the key, I found that I don't have the password.
Is there anything that you can do to restore the key?
February 12, 2009 at 9:01 am
I would contact Microsoft immediately about this one. They need to know about it if they don't, and might have an answer for you if they do.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 12, 2009 at 1:36 pm
MS09-004 fixes a vulnerability in an extended stored procedure for transactional replication. It shouldn't touch SSRS at all, so that leads me to think something else is going on.
Are there any errors in the application event log when you went to restart (before changing the account)? Switching the account is the cause of the problem. You may be able to switch it back. However, that depends on if there was something else going on.
K. Brian Kelley
@kbriankelley
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply