question

DarylandDaryl-1286 avatar image
0 Votes"
DarylandDaryl-1286 asked CarlFan-MSFT answered

Hows is it client (Windows 10 TLS 1.0 enabled) UDL file (SQLOLEDB) successfully connects to server (Windows 2016 TLS 1.0 disabled)?

How is it that a client with TLS 1.0 enabled makes a successful connection to server where TLS 1.0 is disabled and client's UDL file is using SQLOLEDB (Microsoft OLE DB Provider for SQL Server)?

Servers does have TLS 1.1 and 1.2 enabled.

sql-server-generalwindows-server
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

SQLOLEDB is indeed old and dusty. But there was a thread recently where someone had a UDL file with SQLOLEDB and according to the poster, things were working from WIn10 clients but not Win7. So my conclusion is that SQLOLEDB on Win10 has been enhanced to support TLS 1.2. But this is nothing I have investigated or verified.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CarlFan-MSFT avatar image
0 Votes"
CarlFan-MSFT answered

Hi,
Please refer to the information below. Hope they could be helpful.
https://stackoverflow.com/questions/46011694/does-microsoft-ole-db-provider-for-sql-server-support-tls-1-2/46012912
https://community.progress.com/s/article/SQL-server-connection-issues-after-disabling-TLS-1-0
Hope this helps and please help to accept as Answer if the response is useful.
Best Regards,
Carl

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.