Hi,
I've created an always on group with 2 replicas, at first, the automatic failover from primary to secondary was fine. However, when I tried to switch over again from secondary, it didn't success. I had to do it manually to recover the service.
Is it one of the limitations with SQL standard edition? Thanks.
Version: SQL standard edition 2019
Testing method: Stop SQL service to see if the connection breaks.

