I am using report server sql express.

The report was working until yesturday.Sudenly the report did'nt work and give an error :

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 and then restart the service. Check the documentation for more information. (rsReportServerDisabled) Get Online Help
Bad Data.

I delete the key and change the data source.Now it works fine!

My problem is that this is not the first time that it happens!!!

I don't know what the cause of the problem and why suddenly after some times,the report give an erraur that i have to delete the key!!

i would like this not to happen anymore!!

What do i have to do to avoid this

Please help me it's urgent

Thanks alot

Re: problem with key encryption

Daniel Reib

Did you reset (not change, but reset) the password for the user that the Report Server windows service is running as This would cause this message. Did you change the user that the report service is running as

Re: problem with key encryption



Thank you for your answer,when i installed reporting service, i installed the default installation so that now i have in the report server window service account this configurations:

service name: ReportServer$SQLEXPRESS

service account: NT AUTHORITY\NetworkService

built in account: network service.

Does it cause a problem that it's a built in account network service i have a network.what configuration do i have to change so that i will never get the error that i got

For answering your question i didn't change or reset the password i don't even know how to do that!

Help me please!

Thanks in advance

Re: problem with key encryption

Daniel Reib

You should only get this error when you change the service account via the service control panel and not through the report server config tool. What you can try now is running the Report Server Configuration Manager and select the Encryption Keys tab. Then select Delete. This will mean that you will need to re-enter any data source credential information, but should at least bring your server back up.