Azure / Azure/azure-quickstart-templates

sql-server-2014-alwayson-existing-vnet-and-ad VMExtensionProvisioningError 'CreateCluster'

Open
#5,246 3 comments 1 reaction 0 assignees View on GitHub
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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.