Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

restoring reporting services

Posted on 2008-11-03
7
Medium Priority
?
1,202 Views
Last Modified: 2012-08-13
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.  
 
0
Comment
Question by:david_32
  • 4
  • 3
7 Comments
 
LVL 13

Expert Comment

by:St3veMax
ID: 22874994
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
 
LVL 13

Expert Comment

by:St3veMax
ID: 22874999
Typo....You've got issues as the...

Oops!
0
 

Author Comment

by:david_32
ID: 22880831
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
Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

 

Author Comment

by:david_32
ID: 22881784
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
 
LVL 13

Expert Comment

by:St3veMax
ID: 22884024
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
 

Author Comment

by:david_32
ID: 22891708
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
 

Accepted Solution

by:
david_32 earned 0 total points
ID: 23253813
you can't restore a reporting services database that is encrypted if you haven't backed up the key
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

577 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question