none
Move SSRS engine to new server, but keep same reporting databases

    Question

  • We have our SQL Server reporting services (2008 R2) setup as follows:

    ServerA: contains the reporting services engine (including the report manager URL, web service URL and so on).

    ServerB: Is the sql server instance that hosts the reporting databases for ServerA (ReportServer and ReportServerTempDB).

    ServerA is EOL and will be replaced by ServerC. I have two questions:

    1. How do we proceed to install Reporting Services on ServerC so that it points to the databases on ServerB.

    2. How do we migrate the reports (and settings) from ServerA to ServerC.  Will this be automatic by pointing ServerC to the exiting databases on ServerB.

    Thanks.

    Wednesday, July 23, 2014 11:44 AM

Answers

  • Hello,

    All reports / Settings are stored in ReportServer database, so if you Keep your database you have nothing to migrate.

    Install SSRS without configuration on the new machine and afterwards do the configurtaion with Point the "ReportServer" database to ServerB.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Marked as answer by NiborTrassam Thursday, July 24, 2014 2:44 PM
    Wednesday, July 23, 2014 11:53 AM

All replies

  • Hello,

    All reports / Settings are stored in ReportServer database, so if you Keep your database you have nothing to migrate.

    Install SSRS without configuration on the new machine and afterwards do the configurtaion with Point the "ReportServer" database to ServerB.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Marked as answer by NiborTrassam Thursday, July 24, 2014 2:44 PM
    Wednesday, July 23, 2014 11:53 AM
  • OK, thanks. And what happens if we point both the old and new server to the same database for a short time. Is that possible?
    Wednesday, July 23, 2014 11:58 AM
  • That should be possible.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Wednesday, July 23, 2014 12:17 PM
  • In fact it just occurrs to me, would this essentially be doing what scale-out deployment is about?
    Wednesday, July 23, 2014 12:31 PM
  • Sorry, but I don't understand what you mean?

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Thursday, July 24, 2014 7:42 AM