MSSQL 2014 to MSSQL 2022 rolling upgrade is possible using always on

Question

MSSQL 2014 to MSSQL 2022 rolling upgrade is possible using always on

Talha Shaikh 0

0 comments

Answer recommended by moderator

Anonymous

Hi @talha shaikh ,

Thanks for the helpful response and guidance @Marcin Policht .
Adding One important clarification: Always On Availability Groups only support rolling upgrades between adjacent SQL Server versions. Because of this, a direct rolling upgrade from SQL Server 2014 to SQL Server 2022 is not supported. The upgrade would need to be performed sequentially through intermediate versions (2016 → 2017 → 2019 → 2022) or by migrating the database to a new SQL Server 2022 instance.

Thanks,
Akhil.

0 comments

1 additional answer

Your answer

Answer 1

Marcin Policht 109.7K MVP Volunteer Moderator

Follow the approach described in https://bahtisametcoban.home.blog/2019/08/02/always-on-availability-group-with-mixed-sql-server-versions/ (different versions but the underlying concept still applies)

If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

hth

Marcin

Anonymous

2026-03-11T05:04:33.6366667+00:00

Hi @Talha Shaikh ,

Thank you to the community members for contributing to this discussion.

Based on the guidance shared above, the recommended upgrade approach and limitations have been clarified. Since we have not heard back from you, I hope the provided information helped address your concern.

If you still need assistance, please feel free to update the thread and we will be glad to help.

Thank you,
Akhil.