Home > DevOps > Installing the SQL Server 2012 Native Client with PowerShell DSC
Windows PowerShell

Installing the SQL Server 2012 Native Client with PowerShell DSC

This was a gotcha for me. I finally figured out what the issue was after racking my brain for days.

The below Package resource will install the SQL Server 2012 Native Client using a local msi file.

Package InstallSqlServerNativeClient {
    Name = 'Microsoft SQL Server 2012 Native Client '
    Path = 'C:\temp\sqlncli.msi'
    Arguments = 'IACCEPTSQLNCLILICENSETERMS=YES /qn'
    ProductId = 'B9274744-8BAE-4874-8E59-2610919CD419'
    Ensure = 'Present'
    PsDscRunAsCredential = $InstallerCreds
}

Notice the value for the Name parameter. THERE’S A SPACE AFTER THE WORD Client.