Azure / Azure/azure-quickstart-templates
SQL Always on DSC Failure
- Dominant language
- Bicep
- Stars
- 14.9k
- Forks
- 16.2k
- Avg merge
- 6d 21h
- Merged PRs (30d)
- 6
Description
Hi guys i'm trying to deploy the https://github.com/Azure/azure-quickstart-templates/tree/master/sql-server-2014-alwayson-dsc template, it deploys all my resources but fails on provisioning the SQL VM Extension and i have no idea why :(
```
NewAzureRmResourceGroupDeployment :
Resource Microsoft.Compute/virtualMachines/extensions 'vm01SqlC0/sqlAOPrepare' failed
with message 'The resource operation completed with terminal provisioning
state 'Failed
NewAzureRmResourceGroupDeployment : VM has reported a failure when
processing extension 'sqlAOPrepare'. Error message: "Errors occurred while
processing configuration 'PrepareAlwaysOnSqlServer
NewAzureRmResourceGroupDeployment :
Resource Microsoft.Resources/deployments 'deploySqlAlwaysOn' failed with message 'The
resource operation completed with terminal provisioning state 'Failed`
```
`VMExtenstionProvisioningError, the VM has reported a failure when processing extension 'sqlAOPrepare' Errors occured while processing configuration 'PrepareAlwaysOnSqlServer'`
Contributor guide
No contributing guide indexed for this repository
Research direction
Start with the sql-server-2014-alwayson-dsc template and reproduce the deployment failure. Inspect the vm01SqlC0/sqlAOPrepare extension and the PrepareAlwaysOnSqlServer configuration, using the reported VM extension and nested deployment errors as the starting point. Done means identifying the provisioning cause and confirming a successful deployment.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- azure, sql
- Domain
- cloud, databases, infrastructure
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100