SCCM Update 1810 installation warning SQL Server Native Client Update Prerequisite. When istall new 1810 Current Branch 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; Cảnh báo; 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. Để biết thêm thông tin, seehttps://go.microsoft.com/fwlink/?linkid=2026746]
Check the actual SQL server native client. Trong trường hợp của tôi, it is SQL server 2012 native client and the installed version is11.3.6540.0.
Go to thisliên kết 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 download native client 2012 từ đây.
Upgrade SQL Server Native Client
1. Nút chuột phải click the sqlncli and run it với tư cách là quản trị viên. 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?“. Nhấp chuột Đúng.
2. On the Microsoft SQL Server 2012 Native Client setup box, nhấp chuộtKế tiếp;
3. Nhấp chuộtKế tiếp;
4. Nhấp chuộtKế tiếp;
5. To begin the installation clickCài đặt;
6. Nhấp chuộtHoàn thành to complete the setup;
7. Nhấp chuột Đúng to reboot;
8. Check the version of Microsoft SQL Server Native Client and it is now11.4.7001.0.
Back to Bảng điều khiển SCCM. Hướng đến các Updates and Servicing node. Right Mouse Button click Configuration Manager 1810 update and click Run Prerequisite check. You will notice that the SQL Server Native client version step shows completed.