Fix SCCM SQL Server Native Client Update Warning

SQL Server Native Client ftimg scaled

While installing SCCM, you might encounter SQL Server native client warning during prerequisite check. I had described about the warnings in my previous post.

However, the solution wasn’t obvious as I couldn’t cover it in detail. In this post, I will show you how to fix Microsoft SQL Server Native Client related warning. Although you can ignore that warning, but it is always recommended fixing them.

While installing SCCM update, I got the warning at prerequisite check step. Clicking the warning showed the below description.

Install and Update Third Party Applications with Patch My PC
Install and Update Third Party Applications with Patch My PC

[Completed with warning]:Verifies that the version of Microsoft SQL Server Native Client installed on the site server meets the minimum requirements to enable TLS 1.2 support.

The configmgrprereq.log file shows the below warning in detail.

SQL Server Native Client version; Warning; Configuration Manager sites require a supported SQL Server Native Client version. To enable TLS 1.2 support, you must install a supported version of SQL Server Native Client on the specified site database server. For more information, see https://go.microsoft.com/fwlink/?linkid=2026746
SQL Server Native Client TLS 1.2 support
SCCM SQL Server Native Client Update Warning

First of all let’s start by checking the actual SQL server native client. In my case, it is SQL server 2012 native client and the installed version is 11.2.5643.3. The warning appears because the version of client is lower and you need to upgrade this client version.

SQL Server Native Client TLS 1.2 support
Check SQL Server Native Client Version

Before you proceed further you need to know the SQL native client version that you have to download. Go to this link and you will find SQL Server release and the first build that supports TLS 1.2. If you know your installed SQL server version, determine whether your current version of SQL Server already has support for TLS 1.2.

Clicking the above link (the one that we see in log file) takes you here. Click Download button.

SQL Server Native Client TLS 1.2 support
Download Microsoft SQL Server 2012 Native Client

Installing SQL Server Native Client

Right click the sqlncli and run it as administrator. You will now see a warning box. A lower version of product has been detected on your system. Would you like to upgrade your existing installation ?. Click Yes.

SQL Server Native Client TLS 1.2 support
Installing SQL Server Native Client

On the Microsoft SQL Server 2012 Native Client setup box, click Next.

SQL Server Native Client TLS 1.2 support
Install SQL Server Native Client

Click Next.

SQL Server Native Client TLS 1.2 support
Feature Selection

To begin the installation click Install.

SQL Server Native Client TLS 1.2 support
Installing SQL Server Native Client

Finally click Finish to complete the setup.

SQL Server Native Client TLS 1.2 support
SQL Server Native Client Installation Complete

A server reboot is must, click Yes to reboot.

SQL Server Native Client TLS 1.2 support
Restart the Server

Check the version of Microsoft SQL Server Native Client and it is now 11.4.7001.0.

SQL Server Native Client TLS 1.2 support
Verify SQL Server Native Client Version

Back to SCCM console. Go to Updates and Servicing node. Right click Configuration Manager 1810 update and click Run Prerequisite check. You will notice that SQL Server Native client version step shows completed.

SQL Server Native Client TLS 1.2 support
Fix SCCM SQL Server Native Client Update Warning
Need more help?

If you need further assistance on the above article or want to discuss other technical issues, check out some of these options.