patternsqlMinor
Always on high availability groups option is grayed out
Viewed 0 times
groupsalwayshighoptionavailabilitygrayedout
Problem
I'm trying to enable the Always on HA groups using SQL 2016 STD, but the option is grayed out as shown below
any hints on how to enable it would be appreciated.
Regards,
Hussein
any hints on how to enable it would be appreciated.
Regards,
Hussein
Solution
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.
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.
Context
StackExchange Database Administrators Q#317853, answer score: 3
Revisions (0)
No revisions yet.