Can I use SQL Server 2019 to build SQL Server AlwaysON (Availability Group) Under the framework of no domain and DNS server ?

Question

I am trying to use SQL Server 2019 to build SQL Server AlwaysON (Availability Group) Under the framework of no domain and DNS server but fail !!
In the past, I used to use SQL Server 2014 to build SQL Server AlwaysON (Availability Group) Under the framework of no domain and DNS server with no problem !!

Answer 1

Hi @適偉 何 ,

Welcome to Microsoft Q&A!
Windows Server 2016 introduced a new kind of Windows Server failover cluster based on the foundation of the Active Directory-Detached Cluster -- a Workgroup Cluster. A Workgroup Cluster allows SQL Server 2016 to deploy an availability group on top of a WSFC that does not require AD DS. SQL Server requires the use of certificates for endpoint security, just as the database mirroring scenario requires certificates. This type of an availability group is called a Domain Independent Availability Group. Deploying an availability group with an underlying Workgroup Cluster supports the following combinations for the nodes that will make up the WSFC.
For more information, please refer to this document: https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/domain-independent-availability-groups?view=sql-server-ver15
Here is an article for you: Deploy a domain-independent Windows Failover Cluster for SQL Server Always On Availability Groups

Best regards,
Seeya

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.