SCCM 更新 1810 installation warning SQL Server Native Client Update Prerequisite. When istall new 1810 当前分行 Update you can encounter warning message:
[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; 配置管理器 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, 看https://go.microsoft.com/fwlink/?linkid=2026746]
Check the actual SQL server native client. 就我而言, it is SQL 服务器 2012 native client and the installed version is11.3.6540.0.
Go to thislink 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. Or you can 下载 native client 2012 从 here.
Upgrade SQL Server Native Client
1. 鼠标右键 click the sqlncli and run it as administrator. You will now see a warning box: “A lower version of the product has been detected on your system. Would you like to upgrade your existing installation?“. 点击 是的.
2. On the Microsoft SQL 服务器 2012 Native Client setup box, 点击下一个;
3. 点击下一个;
4. 点击下一个;
5. To begin the installation click安装;
6. 点击结束 to complete the setup;
7. 点击 是的 to reboot;
8. Check the version of Microsoft SQL Server Native Client and it is now11.4.7001.0.
Back to SCCM 安慰. 导航至 这 Updates and Servicing node. 右鼠标按钮单击 配置管理器 1810 update and click Run Prerequisite check. You will notice that the SQL Server Native client version step shows completed.
