ERROR : Unexpected database error (-2147159548) 0x80040e21

When I tried an run my Example of "Reporting services" application for the
first time.I got an error "The report server cannot decrypt the symmetric
key............" for which I found a page dedicated to this problem and
the URL is
"http://support.microsoft.com/kb/842421" and when I tried the 3rd step of
"RSKeyMgmt -r InstallationID" . I received an error
"Unexpected database error (-2147159548) 0x80040e21" and the
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer>RSKeyMgmt -r f0b56789-7e84-4igh9-ath4-8rhf0c7a1777
Are you sure you want to delete this key (Y/N)? y
"Unexpected database error (-2147159548) 0x80040e21".
Kindly help!!!!!!!!!!Was wondering if you had any luck solving this problem? I've had the same
issue, and have been unable to resolve for the last 2 months.
Thanks
Marvin
"LazyBugger" wrote:
> When I tried an run my Example of "Reporting services" application for the
> first time.I got an error "The report server cannot decrypt the symmetric
> key............" for which I found a page dedicated to this problem and
> the URL is
> "http://support.microsoft.com/kb/842421" and when I tried the 3rd step of
> "RSKeyMgmt -r InstallationID" . I received an error
> "Unexpected database error (-2147159548) 0x80040e21" and the
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer>RSKeyMgmt -r f0b56789-7e84-4igh9-ath4-8rhf0c7a1777
> Are you sure you want to delete this key (Y/N)? y
> "Unexpected database error (-2147159548) 0x80040e21".
> Kindly help!!!!!!!!!!
>
>

Error - The report server cannot decrypt the symmetric key?

SSRS had been working fine on my comp till the time i insatlled VS 2005. I have started getting following error since VS2005 install

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.

Why does this error cropped and how can i fix it? I am using SQL Server 2000.

Thanks

It cropped because VS.NET 2005 did aspnet_regiis.exe. Assuming that you have backed up your encryption key (you did right?), you can use the Reporting Services Configuration utility to restore it. If no backup, do:

"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\RsKeyMgmt.exe" -d

Then, go to the Report Manager and reset the connection string in all data sources.

|||if the above command is executed, it seems like it will delete all the reporting data also.
is that correct?|||Incorrect. Only the ecrypted information will be nuked, i.e. connection credentials, connection strings, and any secure information stored in subscriptions – by default this is only username & password in File Share delivery extension.|||So the actual data is never encrypted in the Reporting Services db? Then in case I never made a backup of the encryption keys, and I have to delete it now, I wouldn't be losing any data; just
connection strings etc. Where do I go about changing these connection strings? Again a newbie question for you, what is the File Share delivery extension?

Thanks|||Excluding snapshots, the actual data is not stored in the report catalog. Yes, you will loose only the data source credentials. You can go to the Report Manager to change them. FSE is about delivering subsribed reports (users can subscribe to reports believe it or not) to a network file share.

Error - The report server cannot decrypt the symmetric key?

SSRS had been working fine on my comp till the time i insatlled VS 2005. I have started getting following error since VS2005 install

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.

Why does this error cropped and how can i fix it? I am using SQL Server 2000.

Thanks

It cropped because VS.NET 2005 did aspnet_regiis.exe. Assuming that you have backed up your encryption key (you did right?), you can use the Reporting Services Configuration utility to restore it. If no backup, do:

"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\RsKeyMgmt.exe" -d

Then, go to the Report Manager and reset the connection string in all data sources.

|||if the above command is executed, it seems like it will delete all the reporting data also.
is that correct?

|||Incorrect. Only the ecrypted information will be nuked, i.e. connection credentials, connection strings, and any secure information stored in subscriptions – by default this is only username & password in File Share delivery extension.|||So the actual data is never encrypted in the Reporting Services db? Then in case I never made a backup of the encryption keys, and I have to delete it now, I wouldn't be losing any data; just
connection strings etc. Where do I go about changing these connection strings? Again a newbie question for you, what is the File Share delivery extension?

Thanks
|||Excluding snapshots, the actual data is not stored in the report catalog. Yes, you will loose only the data source credentials. You can go to the Report Manager to change them. FSE is about delivering subsribed reports (users can subscribe to reports believe it or not) to a network file share.