Azure / Azure/azure-quickstart-templates
301-sql-alwayson-md-ilb-zones fails when ADE is enabled
- Dominant language
- Bicep
- Stars
- 14.9k
- Forks
- 16.2k
- Avg merge
- 6d 21h
- Merged PRs (30d)
- 6
Description
[301-sql-alwayson-md-ilb-zones](https://github.com/Azure/azure-quickstart-templates/tree/master/301-sql-alwayson-md-ilb-zones)
### Issue Details
Modifying the deployment to work with Azure Disk Encryption causes the deployment to fail when creating the Storage Pool. This appears to be because the StartingDeviceId is hardcoded to 2, meaning that **xSqlCreateVirtualDataDisk NewVirtualDisk** in the DSC package PrepSQLAO.ps1 fails because it only returns a single drive, which isn't sufficient for a Storage Pool.
### Repro steps
1. Modify the VM templates to include Azure Disk Encryption
2. Deploy the DSC extension **prep-sqlao.ps1**
3. Deployment fails with the error message: _Unable to get 2 disks for creating Storage Pool_
Contributor guide
No contributing guide indexed for this repository
Research direction
Start with the 301-sql-alwayson-md-ilb-zones templates and the DSC package entry point prep-sqlao.ps1. Inspect xSqlCreateVirtualDataDisk NewVirtualDisk and its hardcoded StartingDeviceId, then reproduce the deployment with Azure Disk Encryption enabled. Done means the Storage Pool is created successfully when only one drive is returned.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- azure, powershell
- Domain
- cloud, databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 45/100