Azure / Azure/azure-quickstart-templates

301-sql-alwayson-md-ilb-zones fails when ADE is enabled

Open
#5,353 0 comments 0 reactions 0 assignees View on GitHub
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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.