Always on high availability groups option is grayed out
sql serversql-server-2008sql-server-2016
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
Best Answer
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.
The second part is to use T-SQL instead of PowerShell. When I do it this way, the availability groups get created much, much faster and I'm not seeing any of the CPU/thread issues I complained about above. This is the code I'm using to create the Availability Groups with direct seeding. I've adapted it from this blog post:
How can all 4 servers have access to this drive, when I have one server in a different location on a different subnet?
Get really friendly with your network and security teams. Ask them, politely if need be, to create a file share for that folder and allow your service accounts access to said file share.
Other than the service account, this really doesn't have any involvement with SQL Server.
Best Answer
You cant do that. From Microsoft documentation:
And in your image is indicated SQL Server does not reside on a Failover Cluster. Upgrade to sql 2017 or implement a Failover cluster.