Home Forums Reporting Services Reporting Services Replacing the SSRS server, but not the DB server, how to migrate reports? RE: Replacing the SSRS server, but not the DB server, how to migrate reports?

  • September 3, 2013 at 8:25 am

    #1647052

    Talib123 (9/3/2013)

    Use the Repoting services configuration manager on the system you want to move.

    Backup the RS encryption cert . Backup the RS and RSTEMPdb with copy.

    Install SSRS on new machice. Restore original db from server RS and RStemp. Use SSRS config manager to restore the cert.

    Make sure dbs referenced in the data soiurces are present on the server.

    Restart SSRS services.

    Lots of information on the net for this process.

    So, based on this, the reports do "live" in the ReportServer databases? As long as I make sure to backup the encryption key(s,) take a backup of the DBs (just in case, remember, the SQL Server hosting the DBs is a separate machine which is NOT being changed,) then load up the new machine, restore the cert(s), and I should be good to go?

    Well, other then the Devs and users changing their Reporting Services connections...

    Jason