Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Scott
Posting Yak Master
145 Posts |
 Posted - 2007-08-30 : 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.ThanksScott |
|
|
Scott
Posting Yak Master
145 Posts |
Posted - 2007-08-30 : 13:06:55
|
| So I eventually just deleted the encrypted data. RSKeyMgmt -d this brought the report server back up and just required me to re-created the data sources. Still not sure why this happened, didn't change any logins, instances etc...Of interest I found this very nice tool:http://www.sqldbatips.com/showarticle.asp?ID=62It will script almost anything on the report server and will bulk extract the rdl's. |
 |
|
|
|
|
|
Extract reports from broken reporting server