DSC SQL configuration on Azure

This topic contains 1 reply, has 2 voices, and was last updated by  Don Jones 2 weeks, 4 days ago.

  • Author
    Posts
  • #76196

    Martynas
    Participant

    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!

  • #76252

    Don Jones
    Keymaster

    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.

You must be logged in to reply to this topic.