SQL Server version upgrade

Question

SQL Server version upgrade

SVA 116

Hi

Want to upgrade(rolling upgrade) from SQL 2017 on Win 2016 to SQL 2022 on Win 2022 and it is configured with AG . Please provide me the complete steps. Whether we can upgrade to SQL 2022 on Win 2022 and having Always on AG without Widows Failover cluster. Appreciate you support on this.

Thanks

MikeyQiaoMSFT-0444 3,300 Reputation points

2024-07-22T07:45:13.1633333+00:00

Hi，@SVA

Could you please let us know how your issue regarding the rolling upgrade of the AG instance is going? If the answer has successfully resolved your problem, to smoothly close this thread, please feel free to 'Accept it'. This will greatly encourage our work and help others who have similar issues.
MikeyQiaoMSFT-0444 3,300 Reputation points

2024-07-23T06:08:04+00:00

Hi，@SVA

how is your issue going? If you are satisfied with the answer, please don't forget to "Accept it." This will greatly help our work and also assist others who have similar questions. You will also receive appreciation from the community.

Lastly, I wish you all the best!
MikeyQiaoMSFT-0444 3,300 Reputation points

2024-08-02T06:23:44.1066667+00:00

Hi，@SVA

I am not sure if you are receiving my messages. I am currently rechecking this issue. Has your problem been resolved? To better maintain the thread and make our best efforts to address this issue, we are looking forward to your response. If the problem has been resolved, please select "Answer" and "Accept it," as this will effectively help others who have similar issues.

1 answer

Your answer

MikeyQiaoMSFT-0444 3,300 Reputation points

2024-07-22T07:45:13.1633333+00:00

Hi，@SVA

Could you please let us know how your issue regarding the rolling upgrade of the AG instance is going? If the answer has successfully resolved your problem, to smoothly close this thread, please feel free to 'Accept it'. This will greatly encourage our work and help others who have similar issues.
MikeyQiaoMSFT-0444 3,300 Reputation points

2024-07-23T06:08:04+00:00

Hi，@SVA

how is your issue going? If you are satisfied with the answer, please don't forget to "Accept it." This will greatly help our work and also assist others who have similar questions. You will also receive appreciation from the community.

Lastly, I wish you all the best!
MikeyQiaoMSFT-0444 3,300 Reputation points

2024-08-02T06:23:44.1066667+00:00

Hi，@SVA

I am not sure if you are receiving my messages. I am currently rechecking this issue. Has your problem been resolved? To better maintain the thread and make our best efforts to address this issue, we are looking forward to your response. If the problem has been resolved, please select "Answer" and "Accept it," as this will effectively help others who have similar issues.

Answer 1

MikeyQiaoMSFT-0444 3,300

Hi，SVA

Please provide me the complete steps

https://www.mssqltips.com/sqlservertip/2340/resolving-could-not-open-a-connection-to-sql-server-errors/

Whether we can upgrade to SQL 2022 on Win 2022 and having Always on AG without Widows Failover cluster.

To support the Always On availability groups feature ensure that each computer is a node in a WSFC.

Here is a link that provides practical upgrade experiences for your reference.

https://mssqltrek.com/2020/02/12/always-on-availability-groups-rolling-upgrades/

Best Regards,

Mikey Qiao

If you're satisfied with the answer, don't forget to "Accept it," as this will help others who have similar questions to yours.

MikeyQiaoMSFT-0444 3,300 Reputation points

2024-07-24T02:10:50.24+00:00

Hi，@SVA

We haven't received your response for a while now, and we are still looking forward to your thread updates. If you have any questions, please feel free to ask, and we will continue to follow up on your issue.

Moreover, we look forward to you 'ACCEPT' the answer, as this will increase our work efficiency and help us close this thread smoothly. It will also enhance the search relevance of this thread, and you will be appreciated.

Share via

SQL Server version upgrade

1 answer

Your answer