Availability Group creation on SQL2017 only has 2 options

  • oskargunn

    SSCommitted

    Points: 1938

    Hi,

    I want to create an availability group in SQL2017 with "Windows Server Failover Cluster". However this option is missing in the  "Specify Availability Group Options" section. I can only choose EXTERNAL or NONE. Anyone who can point me to the reason why this is like this? :/

    I have already enabled Failover Cluster feature on both replicas and created a cluster.

    Regards,

    Oskar.

  • Site Owners

    SSC Guru

    Points: 80380

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • oskargunn

    SSCommitted

    Points: 1938

    Just to inform you, I have found a probable cause and resolved the issue.

    I think it had to do withe the connection from SqlServer to the failover cluster. When I disabled and enabled AlwaysOn in properties of the instance, the third option appeared in the creation window.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply