dsccommunity / dsccommunity/SqlServerDsc
SqlAG: BasicAvailabilityGroup not compatible with SQL 2016 Enterprise and Developer Editions
Nobody has claimed this yet.
- Dominant language
- PowerShell
- Stars
- 385
- Forks
- 224
- PR merge metrics
- No merged PRs in 30d
Description
Details of the scenario you tried and the problem that is occurring:
The availability group property BasicAvailabilityGroup is available on sql server 2016 or later on a Standard Edition only. If the parameter on this resource is set to True and that the sql instance is 2016 Enterprise or Developper, an error is raised and the availability is not created.
The resource should probably control the Edition before attempting to apply this feature.
Version of the Operating System, SQL Server and PowerShell the DSC Target Node is running:
SQL SERVER 2016 OR LATER
What module (SqlServer or SQLPS) and which version of the module the DSC Target Node is running:
sqlserver
Version of the DSC module you're using, or 'dev' if you're using current dev branch:
dev
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by locating the SqlServerDsc resource handling the BasicAvailabilityGroup parameter and review how SQL Server editions are detected. Reproduce the scenario on SQL Server 2016 Enterprise or Developer Edition. Done means the resource handles the unsupported combination without raising the reported error and the availability group behavior is covered by the relevant tests.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- powershell, sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100