SqlAG/SqlAGReplica: Support `ClusterType` for Always On Availability Groups without cluster

[PwrKjll]

Hello I am currently working on setting AOAG up with Desired State Configuration. Before I started coding, I made a manual setup using Sql Management Studio. Created a Availability Group, set "Cluster type" to "None" and everything is working as wanted.

I want to setup the same thing but in Desired State, and I would greatly appreciate if someone could link to a sample configuration or similar.

[johlju]

Are you looking to set up a Read-scale availability groups without cluster?

The resource does not support it as far as I know, mainly because Microsoft have not added that option to the commands in the SqlServer module which might have made the addition more simple. So the only option is to use other means to configure, for example like suggested in this article Clusterless availability groups.

[johlju]

I was wrong, it seems the commands Join-SqlAvailabilityGroup and New-SqlAvailabilityGroup do have the parameter ClusterType.

[johlju]

Happy to see a PR that adds ClusterType as a parameter to SqlAG and SqlAGReplica.