question

24606055 avatar image
0 Votes"
24606055 asked SeeyaXi-msft answered

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

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 !!

sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

SeeyaXi-msft avatar image
0 Votes"
SeeyaXi-msft answered

Hi @24606055,

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://docs.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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.