Azure / Azure/azure-quickstart-templates

SQL Always on DSC Failure

Open
#1,951 9 comments 0 reactions 0 assignees View on GitHub
bug
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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.