Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Restore of ReportServer and ReportServertempdb Expand / Collapse
Author
Message
Posted Tuesday, May 7, 2013 11:59 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 29, 2013 2:17 AM
Points: 8, Visits: 41
I have to convert a named instance to default instance before that i have taken backups of all databases including reportserver and reportservertempdb.

i have uninstalled the named instance and restored all the user databases after creating the default instance. But user responded the reports are not working.

Do i need to restore the ReportServer and ReportServertempdb as well ? Is there any specific process to follow for restoring ReportServer and ReportServertempdb databases or same as like user databases ?

Thank you for looking into my post. Appreciate all your help regarding this query !
Post #1450411
Posted Wednesday, May 8, 2013 12:32 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 1:30 AM
Points: 112, Visits: 801
databoy (5/7/2013)
I have to convert a named instance to default instance before that i have taken backups of all databases including reportserver and reportservertempdb.

i have uninstalled the named instance and restored all the user databases after creating the default instance. But user responded the reports are not working.

Do i need to restore the ReportServer and ReportServertempdb as well ? Is there any specific process to follow for restoring ReportServer and ReportServertempdb databases or same as like user databases ?

Thank you for looking into my post. Appreciate all your help regarding this query !



Are users able to connect to the SQL Server Reporting services?

It sounds like you tried to restore the ReportServer and ReportServerTempDB?

Have you been in the SQL Server Reporting Services Configuration Manager to change the Server?


--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully
Post #1450420
Posted Thursday, May 9, 2013 8:01 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, July 21, 2014 7:36 AM
Points: 486, Visits: 1,209
Yes, you will need to restore ReportServer and ReportServerTempDB. All of the report definitions are stored in the ReportServer in encrypted fashion. However, after you restore these DB's and start SSRS I believe a new record will be inserted into the ReportServer.dbo.Keys table for the default instance. If you open up that table, you will probably find 2 records - one for the current default instance and one for the old named instance.

There are 2 things that need to happen next:

1 - The old instance record must be removed from the Keys table so SSRS doesn't think we are creating a scale-out SSRS farm

2 - The new SSRS encryption key created for the default instance cannot be used to decrypt the report definitions encrypted with the old key. Hopefully you have made a backup of the SSRS key from the old instance. You can restore the original encryption key using the Reporting Services Configuration utility.



Post #1451124
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse