SQL AG Configuration with Microsoft SQL 2019 Standard Edition

Question

Dear Team,

I currently have a configuration ongoing for Microsoft ALways AG group. We have configured the WSFC, created the AG group but we cannot seem to move forward from the configuration. We see the two errors below when configuring the listener and the readable secondary. Please, note that the two servers are in different locations and belong to two different subnets. We used two seperate ips for the configuration of the cluster and two ips for the AG listener. We also not able to change the readable secondary to yes, as well.

Is there any way we can configure this on the current license just to test? Please, advise.

Answer 1

Hello, Xu Gu

Thank you for the link provided.

I have gone through these steps before; i had the second error when configuring the Listener. Like i mentioned, the two databases are in two different subnets and it is wanting me to provide 2 ips. While providing it, i got the error below:

Also, one of my questions is, can i use AG on the Microsoft standard license? Looking to your feedback.

Answer 2

Hi Admin,

Hope you're doing well.

Please refer to the following doc:

Step-By-Step: Creating a SQL Server Always On Availability Group [6d0d-2ccd-206-13c6] (microsoft.com)

Best Regards