DSC SQL configuration on Azure

DSC
1

Hi,

I am deploying SQL Server 2016 with Windows Server 2016 on Azure from market place with ARM template. Initiating the DSC config for managed disks and sql server. Managed disks works fine, but sql is always failing.

DSC config:
[PRE]
Configuration Main
{

Param ( [string] $nodeName,

    [Parameter(Mandatory)]
   [System.Management.Automation.PSCredential]$SqlInstallCredential

)

Import-DscResource -ModuleName PSDesiredStateConfiguration, xStorage
Import-DscResource -ModuleName xSQLServer -ModuleVersion ‘8.0.0.0’

Node localhost
{
xWaitforDisk Disk2
{
DiskId = 2
RetryIntervalSec = 60
RetryCount = 60
}
xWaitforDisk Disk3
{
DiskId = 3
RetryIntervalSec = 60
RetryCount = 60
}
xWaitforDisk Disk4
{
DiskId = 4
RetryIntervalSec = 60
RetryCount = 60
}
xWaitforDisk Disk5
{
DiskId = 5
RetryIntervalSec = 60
RetryCount = 60
}
xDisk GVolume
{
DiskId = 2
DriveLetter = ‘G’
FSLabel = ‘Apps’
FSFormat = ‘NTFS’
}
xDisk MVolume
{
DiskId = 3
DriveLetter = ‘M’
FSLabel = ‘SQLData’
FSFormat = ‘NTFS’
}
xDisk LVolume
{
DiskId = 4
DriveLetter = ‘L’
FSLabel = ‘SQLLogs’
FSFormat = ‘NTFS’
}
xDisk TVolume
{
DiskId = 5
DriveLetter = ‘T’
FSLabel = ‘SQLTemp’
FSFormat = ‘NTFS’
}

    WindowsFeature 'NetFramework35' {
       Name = 'NET-Framework-Core'
       Ensure = 'Present'
    }

    WindowsFeature 'NetFramework45' {
       Name = 'NET-Framework-45-Core'
       Ensure = 'Present'
    }

    xSQLServerSetup 'InstallDefaultInstance'
    {
        InstanceName = 'MSSQLSERVER'
		SQLCollation = 'SQL_Latin1_General_CP1_CI_AS'

		SQLSysAdminAccounts = $SqlInstallCredential
        SourcePath = 'C:\SQLServerFull\'
        DependsOn = '[WindowsFeature]NetFramework35','[WindowsFeature]NetFramework45', '[xDisk]TVolume'
    }

    }
}

[/PRE]

Error:
“error”: {
“code”: “DeploymentFailed”,
“message”: “At least one resource deployment operation failed. Please list deployment operations for details. Please see https://aka.ms/arm-debug for usage details.”,
“details”: [
{
“code”: “Conflict”,
“message”: “{\r\n "status": "Failed",\r\n "error": {\r\n "code": "ResourceDeploymentFailure",\r\n "message": "The resource operation completed with terminal provisioning state ‘Failed’.",\r\n "details": [\r\n {\r\n "code": "VMExtensionProvisioningError",\r\n "message": "VM has reported a failure when processing extension ‘Microsoft.Powershell.DSC’. Error message: \"DSC Configuration ‘Main’ completed with error(s). Following are the first few: The network name cannot be found. Cannot bind argument to parameter ‘Path’ because it is an empty string. Cannot bind argument to parameter ‘Path’ because it is an empty string.\"."\r\n }\r\n ]\r\n }\r\n}”

Any suggestions highly appreciated!

2

It looks like a resource is expecting a “Path” attribute, and you’ve not provided one. You might re-examine the resource or it’s schema MOF to confirm what it’s expecting.