Saturday, February 25, 2012

My Report Manager is missing...Need help ASAP!

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.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.|||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...
"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.
>
>|||Sounds like you restored your reporting services database to another
server!
If security was set up then you need the keys from the initial server.
Alternatively, do a clean install of reporting services and reload the
reports via visual studio...
This way is alot cleaner and simpler with the nice way one can
"deploy" reports.
Regards,
Tom Bizannes
Reporting Services Designer
Sydney, Australia

No comments:

Post a Comment