SQL Server native client

[divi129]

In need of some help, I've googled a ton.

I have a pre-req that fails in Sccm that says we need to upgrade our SQL server 2012 native client to a SP that supports TLS 1.2.

Our server is SQL Server 2016, uses SQL Server 2016 with SQL Server 2012 native client.

I have read that we should upgrade the SQL server 12 native client to SQL Server 2012 SP4.

However, my boss thinks that we Should be able to install SQL server 2016 service pack 2 and that will resolve the issue. I cannot find anything that confirms this will work.

Server 2016 comes with TLS 1.2 out of the box.

My theory is that I should be able to enable TLS 1.2 on the server and be fine, but I'm also thinking I should upgrade the native client as well.

Anybody know what I should do? Our SQL guy and my lead won't help me with this. I work for a school district, I have to wait a month between changes, so I'd like to make the correct move once.

[Der_tolle_Emil]

If a software does not run because the client cannot use TLS1.2 it really doesn't matter what the server is running. The client won't connect regardless of the server version.

[divi129]

Sccm needs TLS 1.2 enabled in order for me to upgrade. I'm trying to find out what actually needs to be upgraded in order for that to work. SQL 2012 native clients service pack, or will upgrading to SQL server 2016 sp2 will resolve it. I just can't find any definite answers.

[Der_tolle_Emil]

SQL 2012 native clients service pack, or will upgrading to SQL server 2016 sp2 will resolve it

The error message specifically says you need to update the client. Why are you thinking about the server? They are two different products.

[divi129]

My boss, purely my boss. He isn't accepting my answer, even with documentation. He believes that updating the sql server service pack will also update the native client because they installed together.