|
Scott
Posting Yak Master
USA
145 Posts |
 Posted - 08/30/2007 : 10:14:10
|
I have a SQL 2000 box which is out of maintenance, has a drive failure on the C:\ mirror and failed to regenerate when a new drive was put in. It is still running and I am migrating the DB's to a new box.
At the same time reporting services is throwing the following error: (All running on the same box)
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)
From what I have read this is from service accounts being changed, which they haven't. Usually I would reboot the box and hope that fixed it but given the hardware problems I want to get everything off before the reboot.
Is there a way to extract the rdl files from the server without being able to browse to report manager? I then cam move the rdl's to another server.
Thanks
Scott
|
|
Extract reports from broken reporting server
