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.
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.
Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂