Report Server Windows Service (MSSQLSERVER)

I'm really stuck and I'm not sure what I'm supposed to do!?
I've started receiving the following error in my SBS2003 R2 SP2 server
performance report.
Source: Report Server Windows Service (MSSQLSERVER)
Event ID: 120
Total Occurrences: *2
The report server cannot decrypt the symmetric key. Most likely, the service
account or password has changed. To continue, run rsconfig.exe to update the
report server account information.\r\n
I'm not totally sure what commands I need to use with rsconfig.exe.
And I'm not sure if I select Delete from SQL Server 2005\Configuration
Tools\Reporting Services Configuration will cause more problems.
I've tried to Backup encryption key from Reporting Services Configuration
but it gave me the error:
ReportServicesConfigUI.WMIProvider.WMIProviderException: 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.
(rsReportServerDisabled)
at
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.BackupEncryptionKey(Byte[]& encryptedBytes, String password)
which is weird becuase I've never taken a backup when I originally installed
SBS2003 R2 so I can't even Restore the encryption key.
I've tried following the threads but again I'm not totally sure.
http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=cbc4ecc2-1023-4449-9838-5577a9c3b17c&sloc=en-us
Is there a way to correct this using Report Service Configuration tool or
SQL Server 2005'I hit the same issue, I dont know how. I must have installed Reporting
Services at least 6 times and 4 out of 6 times I have had wierd issues
and not the same one. ANyways..
for your problem - I just deleted the encrypted content, hit apply.
Restarted the Reporting Services and then I was able to backup the
keys fine.
On May 22, 5:57 am, ck <c...@.discussions.microsoft.com> wrote:
> I'm really stuck and I'm not sure what I'm supposed to do!?
> I've started receiving the following error in my SBS2003 R2 SP2server
> performancereport.
> Source:ReportServerWindows Service (MSSQLSERVER)
> Event ID: 120
> Total Occurrences: *2
> Thereportservercannotdecryptthesymmetrickey. Most likely, the service
> account or password has changed. To continue, run rsconfig.exe to update =thereportserveraccount information.\r\n
> I'm not totally sure what commands I need to use with rsconfig.exe.
> And I'm not sure if I selectDeletefrom SQLServer2005\Configuration
> Tools\Reporting Services Configuration will cause more problems.
> I've tried toBackupencryptionkeyfrom Reporting Services Configuration
> but it gave me the error:
> ReportServicesConfigUI.WMIProvider.WMIProviderException: Thereportserverc=annotdecryptthesymmetrickeyusedtoaccesssensitiveorencrypteddata
> in areportserverdatabase.Youmusteitherrestoreabackupkeyordeleteallencrypt=edcontent. Check the documentation for more information.
> (rsReportServerDisabled)
> at
> ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(Manag=em=ADentBaseObject mo)
> at
> ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.BackupEncryptionKe=y(=ADByte[]& encryptedBytes, String password)
> which is weird becuase I've never taken abackupwhen I originally installed
> SBS2003 R2 so I can't evenRestorethe encryptionkey.
> I've tried following the threads but again I'm not totally sure.
> http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us...
> Is there a way to correct this usingReportService Configuration tool or
> SQLServer2005'