This blog post is about a situation that initially perplexed me – I was installing SQL Server 2017 onto a new DEMO machine – running Windows Server 2019. This install is one I have done over 50 times, if not more.

Halfway through I got an interesting error that (1) I’ve never seen before and (2) did not expect post SQL Server 2014.

SQL Server Native Client 11.0 download for Windows 7 32 bit It is suppose to work. After searching an hour, MS claims it can be installed as part of the new SQL Server in one of the directories. Jan 19, 2018  The Microsoft® SQL Server® 2012 Native Client is available as part of Microsoft® SQL Server® 2012 Feature Pack, which is updated at each SQL Server 2012 Service Pack. This download is the latest cumulative servicing (QFE) update made to the most recent 2012 Feature Pack release of the SQL Server® 2012 Native Client.

MSI Error: 1706 An installation package for the product Microsoft SQL Server 2012 Native Client cannot be found. Try the installation again using a valid copy of the installation package ‘sqlncli.msi’.

And it then asked me to locate the install files for SQL Server 2012 Native Client.

I (obviously) could not find those as I had not installed it – so I downloaded the native Client off Microsoft’s website and then proceeded to get this error:

At which point I wondered what the heck was going on….

Select Format to Download - Tumhen Apna Saathi Banane Se Pehle. Tumhen Apna Saathi Banane Se Pehle. Click Here & Download. MP3 - 128 KBPS. Listen song online. Related Songs. Chahe Lakh Toofan Aayen. Size: 5.99 MB, Downloads: 8895 by Lata Mangeshkar, Shabbir Kumar. Tumhe apna sathi banane se mp3 song download. Select Format to Download - Tumhe Apna Banane Ka-Chaand Chhupa mp3 song. Tumhe Apna Banane Ka-Chaand Chhupa. Size: 4.44 MB. Click Here & Download. MP3 - 128 KBPS. Tumhe Apna Banane Ka-Chaand Chhupa. O Saathi - Humsafar. Size: 11.65 MB, Downloads: 35877 by Nikhita Gandhi, Ash King.

Until I remembered that unlike my normal setup I had installed Visual Studio 2019 on the VM first. So I looked in Programs and Features and lo and behold there was SQL Server Native Client:

I also noticed SQL Server 2016 LocalDB which is installed by Visual Studio – which I made a note to upgrade to version 2017 as this can cause issues with things like the TRANSLATE function that was introduced in SQL Server 2017.

So I uninstalled SQL Server 2012 Native Client and reinstalled SQL Server 2017 Developer Edition and boom!! – it worked.

Yip.