Darrell wrote:
> I seem to be able to run and view reports in the Report Manager. In
> fact, I can do just about everything I need to do. I have created a push
> subscription with not problem, and even worked on the development
> server. When I moved the report to the production server and created the
> subscription, everything looks good. Even the job in SQL Server appears
> to be running to successful completion. However, no report get sent via
> email.
>
> Here is the more important issue. When I stop and restart Reporting
> Services, I inspect the log files. Here is what I get in the file
> ReportServerService_06_17_2005_09_24_46.log:
>
> ReportingServicesService!library!2064!6/17/2005-09:24:47:: e ERROR:
> Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDisabledException:
> 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., ;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDisabledException:
> 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. --->
> System.Runtime.InteropServices.COMException (0x80090005): Bad Data.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ImportSymmetricKey(Byte[] pSymKeyBlob)
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> --- End of inner exception stack trace ---
> ReportingServicesService!library!2064!6/17/2005-09:24:47:: Exception
> caught while starting service. Error:
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDisabledException:
> 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. --->
> System.Runtime.InteropServices.COMException (0x80090005): Bad Data.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ImportSymmetricKey(Byte[] pSymKeyBlob)
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> --- End of inner exception stack trace ---
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
> Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()
> ReportingServicesService!library!2064!6/17/2005-09:24:47:: Attempting to
> start service again...
>
> It appears to be complaining about bad data in the symmetric key. What
> gives? What should I do to fix this?
>
> Thanks in advance.
>