Comments on: Fix SCCM SQL Server Native Client Update Warning https://www.prajwaldesai.com/sccm-sql-server-native-client-update-warning/ SCCM | ConfigMgr | Intune | Windows 11 | Azure Sun, 14 Nov 2021 17:40:53 +0000 hourly 1 https://wordpress.org/?v=6.4.1 By: Martin https://www.prajwaldesai.com/sccm-sql-server-native-client-update-warning/#comment-23339 https://www.prajwaldesai.com/?p=210438#comment-23339 Hello,
I have sql native client version 11.4.7462.6 installed on my mecm server and I have still this alert:
SqlNativeClient is already installed (Product Code: {9D93D367-A2CC-4378-BD63-79EF3FE76C78}). But to support TLS1.2, a new version with Product Code: {B9274744-8BAE-4874-8E59-2610919CD419} needs to be manually installed.
I use Microsoft SQL Server 2019 (RTM-CU9) (KB5000642) – 15.0.4102.2 (X64) .
What Can I do with this problem? Thank you for your help.

]]> By: Ashok https://www.prajwaldesai.com/sccm-sql-server-native-client-update-warning/#comment-17387 https://www.prajwaldesai.com/?p=210438#comment-17387 good it is helpful

]]> By: Dominique https://www.prajwaldesai.com/sccm-sql-server-native-client-update-warning/#comment-17247 https://www.prajwaldesai.com/?p=210438#comment-17247 I have just installed SCCM 2006

]]> By: Dominique https://www.prajwaldesai.com/sccm-sql-server-native-client-update-warning/#comment-17246 https://www.prajwaldesai.com/?p=210438#comment-17246 Hello,

I installed msiexec /i sqlncli.msi ADDLOCAL=ALL APPGUID={0CC618CE-F36A-415E-84B4-FB1BFF6967E1}
but not sure if the prerequisites is correct now as it was not stopping the installation … So I have an upgrade from 11.3.6530.0 to 11.4.7001.0… Ho to check if it is correct?

I have SQL 13.0.5102.14 running …

Thanks,
Dom

]]> By: Carola https://www.prajwaldesai.com/sccm-sql-server-native-client-update-warning/#comment-16823 https://www.prajwaldesai.com/?p=210438#comment-16823 Hi Prajwal,
I already ha e 10.4.7001 sql native client installed, but in the prerequisite check I see the warning that the sql native client need to have TLS 1.2… unfortunately I proceeded with tha 1910 upgrade even if the prerequisite check warning me in February 2020 and every thing seems to be ok. Now that I need to import a new operative system image In the content status I see the import in progress But never finish. It stack on “ Detail will be available after the server finishes processing the messages.”
I’m afraid the reason is my upgrade. Is it possible? Now I try to fix my sql native client problem in the registry: I change SSL with this indication
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2]
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2\Client] “DisabledByDefault”=dword:00000000 “Enabled”=dword:00000001
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2\Server] “DisabledByDefault”=dword:00000000 “Enabled”=dword:00000001
But nothing changed…
I hope you can help me
Thank u in advance

]]> By: Nat https://www.prajwaldesai.com/sccm-sql-server-native-client-update-warning/#comment-15161 https://www.prajwaldesai.com/?p=210438#comment-15161 In reply to Prajwal Desai.

Thank you for your response. I was able to run the install from the downloaded content on the SCCM server and I now have the updated SQL Native client and all prerequisites are good to go and ready for the upgrade.

]]> By: Prajwal Desai https://www.prajwaldesai.com/sccm-sql-server-native-client-update-warning/#comment-15153 https://www.prajwaldesai.com/?p=210438#comment-15153 In reply to Nat.

I have covered that info in the post. You need to first determine your current sql server native client version. Then go the MS link and use the download links to obtain the server updates that are applicable to your environment.

]]> By: Nat https://www.prajwaldesai.com/sccm-sql-server-native-client-update-warning/#comment-15118 https://www.prajwaldesai.com/?p=210438#comment-15118 Hi Prajwal,

I need to understand what SQL Native client update I should apply when the version of the current Native Client reads 11.3.6020? Your help would be most appreciated.

Thanks
Nat

]]> By: AJP https://www.prajwaldesai.com/sccm-sql-server-native-client-update-warning/#comment-13603 https://www.prajwaldesai.com/?p=210438#comment-13603 Hi,

Do you have to upgrade the SQL Server Native Client for the TLS 1.2 warning on your Primary Server or your DB Server?

Thanks.

]]> By: Prajwal Desai https://www.prajwaldesai.com/sccm-sql-server-native-client-update-warning/#comment-13554 https://www.prajwaldesai.com/?p=210438#comment-13554 In reply to Amy.

The link is provided in the post but let me provide it here – https://support.microsoft.com/en-in/help/3135244/tls-1-2-support-for-microsoft-sql-server

Check the How to know whether you need this update section and download the correct native client update.

]]>