3

I'm trying to enable the Always on HA groups using SQL 2016 STD, but the option is grayed out as shown below

enter image description here

any hints on how to enable it would be appreciated.

Regards,

Hussein

2
  • Please, run this query and add output to your question: select @@version;
    – user_0
    Commented Oct 5, 2022 at 9:38
  • The other problem you have is you mentioned you're running Standard Edition but AlwaysOn Availability Groups is an Enterprise-only feature.
    – J.D.
    Commented Oct 5, 2022 at 13:13

1 Answer 1

3

You cant do that. From Microsoft documentation:

Prior to SQL Server 2017, and Windows Server 2016, the instance had to reside on a Windows Server Failover Cluster (WSFC) node to enable the Always On availability group feature

And in your image is indicated SQL Server does not reside on a Failover Cluster. Upgrade to sql 2017 or implement a Failover cluster.

1
  • you just nailed it, many thanks. Commented Oct 5, 2022 at 10:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.