Azure / Azure/azure-quickstart-templates
sql-server-2014-alwayson-existing-vnet-and-ad VMExtensionProvisioningError 'CreateCluster'
- Dominant language
- Bicep
- Stars
- 14.9k
- Forks
- 16.2k
- Avg merge
- 6d 21h
- Merged PRs (30d)
- 6
Description
Template Name: **sql-server-2014-alwayson-existing-vnet-and-ad**
This template deployment is failing in this extension processing:
"_Resource Microsoft.Compute/virtualMachines/extensions 'test-sql-1/CreateCluster' failed with message_"
The error detail of the error is below and is related to **xSqlEndpoint** configuration section.
_"Following are the first few: The input object cannot be bound to any parameters for the command either because the command does not take
pipeline input or the input and its properties do not match any of the parameters that take pipeline input. "_
### Issue Details
New-AzureRmResourceGroupDeployment : 4:47:00 PM - Resource Microsoft.Compute/virtualMachines/extensions 'test-sql-1/CreateCluster' failed with message '{
"status": "Failed",
"error": {
"code": "ResourceDeploymentFailure",
"message": "The resource operation completed with terminal provisioning state 'Failed'.",
"details": [
{
"code": "VMExtensionProvisioningError",
"message": "VM has reported a failure when processing extension 'CreateCluster'. Error message: \"DSC Configuration 'CreateFailoverCluster' completed
with error(s). Following are the first few: The input object cannot be bound to any parameters for the command either because the command does not take
pipeline input or the input and its properties do not match any of the parameters that take pipeline input. The PowerShell DSC resource
'[xSqlEndpoint]SqlAlwaysOnEndpoint' with SourceInfo
'C:\\Packages\\Plugins\\Microsoft.Powershell.DSC\\2.76.0.0\\DSCWork\\create-failover-cluster.ps1.0\\CreateFailoverCluster.ps1::273::9::xSqlEndpoint' threw one
or more non-terminating errors while running the Set-TargetResource functionality. These errors are logged to the ETW channel called
Microsoft-Windows-DSC/Operational. Refer to this channel for more details. The input object cannot be bound to any parameters for the command either because
the command does not take pipeline input or the input and its properties do not match any of the parameters that take pipeline input.\"."
}
]
}
}'
Contributor guide
No contributing guide indexed for this repository
Research direction
Start with the sql-server-2014-alwayson-existing-vnet-and-ad template and its xSqlEndpoint configuration. Inspect CreateFailoverCluster.ps1 at the reported line 273 and review the Microsoft-Windows-DSC/Operational log for the CreateCluster extension. Done means the template deployment completes without the xSqlEndpoint binding error.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- azure, powershell
- 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