Dsc - Sql Alias

dsc_sqlAlias_simple.ps1

#Install-PackageProvider -Name Nuget -MinimumVersion 2.8.5.201
Configuration sqlAlias
{
    Import-Module PSDesiredStateConfiguration -ErrorAction SilentlyContinue
    Import-Module xSQLServer -ErrorAction SilentlyContinue
    
    if ((get-module -Name PSDesiredStateConfiguration) -eq $null){
        Install-Module PSDesiredStateConfiguration -Force
        Import-Module PSDesiredStateConfiguration
    }
    if ((get-module -Name xSQLServer) -eq $null){
        Install-Module xSQLServer -Force
        Import-Module xSQLServer 
    }

    Import-DscResource -ModuleName xSqlServer

     node $env:ComputerName {
        xSQLServerAlias Add_SqlAlias_TCP
        {
            Ensure               = 'Present'
            Name                 = 'sql'
            ServerName           = "servername"
            Protocol             = 'TCP'
            TcpPort              = 1433
            #PsDscRunAsCredential = $SysAdminAccount
        }
     }
}

sqlAlias
Start-DSCConfiguration -ComputerName $env:ComputerName -Path .\sqlAlias -Wait -Verbose