question

lmsytner avatar image
lmsytner asked

SQL Server 2017 Workgroup Failover Cluster Instance

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. :(

sqlsql serverclusterfailover
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
manchun avatar image
manchun answered

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.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.