restoring reporting services

Can you restore reporting services from a  tape backup? How would you go about doing that

I am asking because I deleted encrypted content without backing up the key (I backed up the databases though and restored them. - I now cannot get into report manager.  
 
david_32Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

St3veMaxCommented:
You've not got issues as the installation ID in the database may not match the installation ID of the server SSRS is installed on.

To get over the encryption issue; You need to use the RSKeyMgmt utility to get this working:

http://msdn.microsoft.com/en-us/library/ms162822.aspx

This will also help reset the installation ID's in the database and the report server.

HTH
0
St3veMaxCommented:
Typo....You've got issues as the...

Oops!
0
david_32Author Commented:
that may be right.

so I guess I need to user rskeymgmt -r to remove the install id ..but what do I do to put it back?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

david_32Author Commented:
Just a bit more background on my problem

In reporting manager I get the error:
An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

the log file says
w3wp!library!7!11/05/2008-08:43:50:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., Incorrect security descriptor version

I don't see anything too interesting in the event logs.

When I use a new reportserver db all is ok (except lost all my data). Restoring the old one is the problem


Does this still sound like installion id problem?
0
St3veMaxCommented:
Yes. As your installation related to that DB. I cant remember the option; but looking into the RSKeyMgmt should give you which option it is.
HTH
0
david_32Author Commented:
From my understanding reading the RSKeyMgmt doco the installationID is the encryption key. And to replace it you need  to have a backup of the encryption key so you can restore it to make the database work. Is that what you are thinking?

The reason why I ask is because.. I have heard of instances where people have deleted encrypted content (which includes the keys) and it has not stopped Report Manager from working.
0
david_32Author Commented:
you can't restore a reporting services database that is encrypted if you haven't backed up the key
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.