I am using RS 2003. I retrieved this from the log files. How do I fix this.
Will reinstall fix it.
<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.1038.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServerService__10_18_2007_10_13_30.log</Path>
<SystemName>EAVARCHSQLR01</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
ReportingServicesService!servicecontroller!50c!10/18/2007-10:13:30:: Service
controller exiting.
ReportingServicesService!crypto!bec!10/18/2007-10:13:30:: i INFO:
Initializing crypto as user: NT AUTHORITY\SYSTEM
ReportingServicesService!crypto!bec!10/18/2007-10:13:30:: i INFO: Exporting
public key
ReportingServicesService!crypto!bec!10/18/2007-10:13:30:: i INFO: Performing
sku validation
ReportingServicesService!crypto!bec!10/18/2007-10:13:30:: i INFO: Importing
existing encryption key
ReportingServicesService!library!bec!10/18/2007-10:13:30:: 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!bec!10/18/2007-10:13:30:: 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!bec!10/18/2007-10:13:30:: Attempting to
start service again...
[quoted text, click to view] "Bruce L-C [MVP]" wrote:
> What version are you on?
>
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "OriginalStealth" <OriginalStealth@discussions.microsoft.com> wrote in
> message news:380BDB1A-AAF2-43B3-BE79-E525E6D2E260@microsoft.com...
> > Cannot find the report manager. I tried starting the Report Manager from
> > the
> > start menu on the server and received this error "Page cannot be
> > displayed".
> > I then tried from the authoring comupter start menu and got the same
> > message.
> > I then tried to deploy a report to the site and received and error "cannot
> > connect to the report server". I have never gotten these messages before.
> > There was some recent work on the server but that shouldn't affect RS
> > should
> > it. Any ideas?
> >
> > Thanks in advance.
>
>