I am trying to set up a SQL Server 2017 'workgroup' failover cluster instance.
The Windows Server Failover Cluster is installed and I've created a CLUSTER using SERVER1 and SERVER2.
When attempting a new SQL Server failover cluster installation though I get stuck during the section: 'Server Configuration'
Specifically it appears to require that the service accounts are 'domain' accounts. This seems to defeat the purpose of a 'workgroup' failover cluster.
Is this a bug with the installer? Is there any way to work around this?
In the meantime I suppose I will start investigating database mirroring between stand-alone workgroup instances instead. :(
Answer by manchun ·
In a SQL server the Always On availability groups aren't reliant upon SQL Server Failover Clustering, you can utilize a failover cluster instance (FCI) to have an accessibility reproduction for an accessibility gathering.
What is a Failover Cluster Instance in SQL Server?
It is essential to know the job of each clustering innovation and to realize what contemplation are fundamental as you plan your Always On accessibility groups environment.
How can I determine the fundamental accessibility groups for my FCIs?
The main exemption is that while being relocated to another WSFC bunch, an accessibility cluster can incidentally straddle two groups. Watch out for that.