locked
In-Place Upgrade and SSRS RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    We have a Windows 2012R2 Server that is a SQL Server 2012 server with native SSRS installed. We plan to upgrade in place to Windows Server 2016 and SQL Server 2016.  Will we need to do anything special for SSRS or IIS after the upgrade or will everything stay intact?  Thanks.
    Monday, June 26, 2017 8:08 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Before upgrading

    1) Take SQL Backups of ReportServer and ResportServerTempDB

    2) Connect to SSRS through via InternetExplorer and take backups of Encryption keys with password

    3) Once the SQL Server 2016 installed

    4) Restore the SQL Backups of 2012 from step 1

    5) Configure SSRS to use with existing restored databases ( 2012 databases)

    6) Restore encryption key from step 2

    7) Restart the SQL SSRS services

    https://www.mssqltips.com/sqlservertip/2692/migrating-sql-reporting-services-to-a-new-server-by-moving-the-reporting-services-databases/

    Before doing please test this setups....

    Thanks, Satish Kumar. Please mark as this post as answered if my anser helps you to resolves your issue :)


    Monday, June 26, 2017 8:43 PM