Yesterday (10/12) SQL Server 2000 Reporting Services was working fine. I
just installed the XP patches from Tuesday 10/10/2006, using Microsoft
Update, and SS2K RS gives the following:
Details
Product: SQL Server Reporting Services
Event ID: rsReportServerDisabled
Source:
Microsoft.ReportingServices.Diagnostics.Utilities. ErrorStrings.resources.Strings
Version: 8.00
Message: Unable to encrypt or decrypt data managed by the Report Server
instance. Please refer to the Reporting Services online help for guidance in
enabling this functionality.
Explanation
A symmetric key is a single key used to encrypt and decrypt data. Reporting
Services encrypts the symmetric key itself, using the public key of a
specific user account on a specific computer. This error occurs when the
public key that the user account provides does not match the public key that
report server is expecting. Conditions that cause this error to occur include
changing the name of a report server instance, moving the report server
instance to a different computer, or changing the account under which the
Report Server service runs.
User Action
A system administrator on the computer running the report server service can
use a backup copy of the public key to get the report server running again.
Use the rskeymgmt utility to apply the backup key set. If you do not have
backup of the key, you must run the rskeymgmt utility to delete all of the
encrypted content, run the rsconfig utility to respecify the encrypted
connection values used to connect to the report server database, restart the
service, and retype stored credentials for all reports that use stored
credentials. For more information this utility, search Books Online.
--------------------------------------------------------------------------------
Currently there are no Microsoft Knowledge Base articles available for this
specific error or event message. For information about other support options
you can use to find answers online, see
http://support.microsoft.com/default.aspx.
Having followed the instructions to restore the symmetric key, which went
through successfully, I still get the same error, which on the Report Manager
page is:
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.
WHAT HAS BEEN UPDATED IN THE TUESDAY BATCH THAT I NEED TO BACK OUT?
KINDLY FIX THE PATCH(ES) AS WE HAVE PRODUCTION SERVERS THAT WE CANNOT APPLY
THESE PATCHES TO WITHOUT FIXES.
AS THE MACHINE HAVING THE PROBLEM IS A DEVELOPMENT BOX, THIS IS "TESTING"
AND THE PATCH(ES) APPEAR TO HAVE ISSUES.