0

We have an SQL Server database engine on the 2016 version. We also have SSRS in the 2016 version. I plan to upgrade the SQL database engine from the 2016 version to the 2017 for it to participate in AG with the 2017 database server.

After SQL Database engine upgrades from 2016 to 2017(that has SSRS reporting databases), will SQL 2016 SSRS connect to upgraded SQL 2017 with no issues? We plan to take VM snapshot of the box with SQL 2016 server installed.

Improve this question
4
  • So you are going to do in-place upgrade the instance with ReportServer database?
    – SergeyA
    Commented Aug 16, 2023 at 15:55
  • yes, that is correct
    – mk SQL
    Commented Aug 16, 2023 at 21:00
  • I don't see any issue in this approach other than I don't like in-place upgrade.
    – SergeyA
    Commented Aug 16, 2023 at 22:03
  • I agree. Thank you for your reply
    – mk SQL
    Commented Aug 17, 2023 at 12:24

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.