question

PhilButler-7429 avatar image
0 Votes"
PhilButler-7429 asked AmeliaGu-msft commented

SQL Always On availability group is failing over without taking WSFC

Hi

So we built our first SQL 2017 Always On availability group but occasionally it is automatically failing over without taking the windows cluster with it so the alias points to the secondary instance which takes the system down :(.

Is there something obvious we have done wrong?

Technically I don't need automatic failover (althoughI would prefer it) but when I switched it off Windows failed over but sql did not.

Thanks in advance
Phil

sql-server-generalwindows-server-clustering
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@PhilButler-7429 Can you please explain what do you mean by AG failover without failing over WSFC. Also do you have any error message ?

0 Votes 0 ·

Hi @PhilButler-7429,,
Did the answers help you?
Please feel free to let us know if you have any other question.
If you find any post in the thread is helpful, you could kindly accept it as answer. This would benefit the community, and encourage the community member to keep working on your issues.
Best Regards,
Amelia

0 Votes 0 ·
DavidBrowne-msft avatar image
0 Votes"
DavidBrowne-msft answered

so the alias points to the secondary instance

Verify Client Access Point (CAP) for the AG Listener is in the same Cluster Resource Group as the Availability Group, which will force them to always be up on the same node.

If this is a multi-subnet cluster under the default configuration the CAP is configured with two IP addresses. Some older clients will always try to connect to the first of the IP addresses returned, which can appear as though they are attempting to connect to the secondary instance.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

TomPhillips-1744 avatar image
1 Vote"
TomPhillips-1744 answered
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

Hi @PhilButler-7429,

Please make sure you are connecting to AlwaysOn listener because this will route traffic automatically to the intended primary replica without having to manually update the connection string after every failover.
If you haven’t configure the listener, please refer to Configure a listener for an Always On availability group which might help.

Best Regards,
Amelia



If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.