Moving the SQL 2005 SSRS Databases to a SQL 2008 server

  • I am running SSRS 2005 in a server and the SQL SSRS DBs are located in a different server running SQL 2005 standard edition; we want to move the SSRS databases from the SQL 2005 server to a new and more powerful box running SQL 2008 Standard edition but keep SSRS running the SQL 2005 standard edition. What are my options here?

  • You should be fine with 2008 db engine hosting the SSRS 2005's databases.

    BACKUP YOUR ENCRYPTION KEY FIRST!

    Process would be fairly simple, stop SSRS, restore reportserver and reportservertempdb to the 2008 box, and run the ssrs configuration tool to point at the new DB server. if that failed, then you've still got the original db's, so change the configuration to point back to the 2005 box.

    You should make sure that you've got a recent version of .net installed (probably 3.5 sp1).

  • This should work OK. It is also OK to install SSRS 2008 on a SQL 2005 server.

    If you want to migrate the SSRS objects to a newer version of SSRS, then take a look at RS Scripter from sqldbatips.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

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

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