Share via

SQL Server Creating Availability Groups Error

amomen 381 Reputation points
2021-05-08T12:02:59.77+00:00

Hello everybody!

I am trying to create an Availability Group in SQL Server with the wizard but face the error code 19417 on the last step with the following message:

An attempt to fail over or create an availability group failed. This operation is not supported when Always On Availability Groups is running under a remote Windows Server Failover Clustering (WSFC) cluster context. Under a remote cluster context, failing over or creating availability groups are not supported. (Microsoft SQL Server, Error: 19417)

Could you tell me what the solution is? I really appreciate your help.

Regards,
Ali

@Erland Sommarskog , @Viorel , @MelissaMa-MSFT

SQL Server | Other
Accepted answer
  1. CathyJi-MSFT 22,396 Reputation points Microsoft External Staff
    2021-05-10T06:03:49.357+00:00

    Hi @amomen-8749

    According to MS document, Availability groups are not supported on domain controllers.

    After you creating another VM for SQL AG, did the issue is still occurred?

    By the way, suggest you reading the MS document Prerequisites, Restrictions, and Recommendations for Always On availability groups to help you avoiding many problems.

    If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator
    2021-05-08T15:48:11.287+00:00

    SQL Server on domain controllers has never been a good idea.

    1 person found this answer helpful.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.