Restore of ReportServer and ReportServertempdb

  • 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 !

  • 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 😀

  • 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.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply