SQL Server Installation for a Distributed Availability Group

All we need is an easy explanation of the problem, so here it is.

I am deploying a SQL Server 2019 Distributed Availability Group. I have created a WSFC at each of my two sites (spanning two servers each). Upon installing SQL Server, it is not clear to me if I should select the "SQL Server Stand-Alone" installation or the "SQL Server Cluster Installation"? I do not wish to deploy a SQL Server Failover Cluster Instance (FCI).

Thank you. J.

How to solve :

I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.

Method 1

You will select "SQL Server Stand-Alone" installation.

To create a distributed availability group, you must create two availability groups each with its own listener. You then combine these availability groups into a distributed availability group.

Once you do that on all nodes you can use these instructions to configure the Always On distributed availability group.

Configure an Always On distributed availability group

Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply