My Surface 3 with Win 8.1 crashed and now I have a new Surface with Win 10. Can someone give me a link to download the appropriate version of SQL Server Client tools for Win 10. I only want SQL Server Management Studio on my Surface not the full installation with the DB engine. I am connecting to a 2008 SQL server. Where can I download Microsoft SQL native client 10.0 only.

Sql Server Native Client 10.0 Download

Few days ago, I had a task to check if SQL Native Client version 11 was installed on some server in our environment. Of course, I could have logged in to all of my servers and check manually, but why I should do that if I could achieve the same thing with PowerShell. And it would be faster and simpler.

Just a little bit of a background first: SQL Native Client 11 is installed when you install SQL Sever 2016. It could be installed separately, without installing SQL Server 2016, it is included with SQL Server 2012 Feature Pack. Also, you could download only SQL Native Client 11 .msi install file, from this web page:
SQL Native Client 11 download page

I went to Installed Programs and verified that SQL Native Client 11 was not installed:

Also, I have checked the registry -> HKLM:SoftwareMicrosoft – there was not SQL Native Client 11 installed:

In order to install SQL Native Client 11 with PowerShell, I will check the registry for the installation. If it is not there, I will start msiexec.msi and install SQL Native Client 11 silently.

So first, lets search the registry for the installation:

This will give us the list of all registry keys which are located under HKLM:SoftwareMicrosoft location.

It will look something like this:

As you may see, we have a list of keys which contain ‘Client’ in its name, but none of those are SQL Native Client 11.

Now, we have to go thru this list and make sure that in case that there is no SQL Native Client 11 present, we could proceed with the installation.

I have split all the names into sections, using Split():

Sql Server Native Client 10.0 Windows 7

The result looks like this:

Now that we have the names, we could do if loop and check if there is ‘SQL Native Client 11’ installed:

If there is SQL Native Client 11 installed, that is fine, we can finish because we have already installed. But in case we don’t have it installed, we could move forward and start the installation.

Sql Server Native Client 11 For Windows 10

I have downloaded SQL Native Client 11, and have placed it in C:tempSQLNativeClient11.

Sql Server Native Client 11.0 For Windows 10

We will use msiexec.msi tool for the installation of SQL Native Client 11.

The parameters we will use are:

• /i — install
• /qn — quiet installation
• IACCEPTSQLNCLILICENSETERMS=YES — will accept license without asking us (needed for the silent install)
• /L*V C:tempSQLNativeClient11sqlNativeClientInstall.log — capture the log and save it

In the end, we will check if the SQL Native Client 11 is installed, by doing almost the exactly the same thing like at the beginning, checking the registry.

Sql Server Native Client 10.0 For Windows Xp Download

So, that is it. It was really a small piece of code, but you could use this together with other installations, updates, and so on.

Sql Server Native Client For Windows 10