Migrate/Upgrade report server RRS feed

  • Question

  • Hello everyone,

    we have Skype for Business enterprise pool with Monitoring back-end on Windows 2012 R2 and SQL 2014. and we have SSRS running on Windows Server 2008 R2 and on SQL 2008 R2.

    We want to migrate our reports to Windows Server 2012 R2 and SQL Server 2016. What would the procedure for that? I have not found any proper information on how do all this. Should we have to migrate anything at all? Or just deploy reports o new SSRS pointing to Monitoring database?

    Wednesday, February 8, 2017 2:06 PM

All replies

  • Hi Arturas,

    You could refer to the following steps to update it:

    1. Install SQL 2016 on Windows server 2012 R2, make sure all data which are copied from SQL 2008R2 have been copied to SQL 2016: https://msdn.microsoft.com/en-us/library/ms156421.aspx
    2. Re-define the topology with SQL 2016
    3. Re-run deploy wizard about “Deploy Monitoring Reports ” with instance on SQL 2016

    Best Regards,
    Jim Xu
    TechNet Community Support

    Please remember to mark the replies as answers if they helped.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    • Proposed as answer by jim-xu Monday, February 13, 2017 9:49 AM
    Thursday, February 9, 2017 6:10 AM