Installing Microsoft® SQL Server® 2012 Native Client

I have encountered an quite funny error while installing some extra features to my visual studio installation.

There is a problem with this Windows Installer Package. A DLL required for this installation to complete could not be run. Contact your support personnel or package vendor

I traced the error to the SQL Server 2012 Native client installation and when I ran the “sqlncli.msi” package the error was the same.

After googling around for a few hours and trying out everything you could think of (windows reinstall not included) I investigated a litte further.

There is a installation log located in “\appdata\local\temp\msi96155.log”. Not really sure if the name is always the same but you can find it quite easily (order by date).

In there there was

Error 1723. There is a problem with this Windows Installer package. A DLL required for this installation to complete could not be run. Contact your support personnel or package vendor. Action SNAC_SetClientSSNLDefaults_32, entry: SNAC_SetClientSSNLDefaults, library: C:\windows\Installer\MSI45BE.tmp
=== Logging stopped: 5.1.2018 13:07:09 ===

Ok… next stop  downloading ORCA MSI Editor.

Open the file “sqlncli.msi” in the editor and search for “SNAC_SetClientSSNLDefaults_32” I noticed that when comparing the client for sql 2010 that the value there was ($DP_sqlncli10_dll_32 = 3) and it installed correctly. We know that the name of the dll in system32 folder is sqlncli11.dll for SQL 2012 why not change it here?

orcaChange the value to ($DP_sqlncli11_dll_32 = 3), save and install.

Be sure that you edit this in all sqlncli.msi files. I found mine here

“C:\ProgramData\Microsoft\VisualStudio\Packages\sqlncli,version=15.1.61710.120,chip=x64,language=en-US”

C:\ProgramData\Package Cache\{49D665A2-4C2A-476E-9AB8-FCC425F526FC}v11.0.2100.60\packages\sqlncli_amd64