Author Topic: 'Microsoft OLE DB Driver for SQL Server' is not supporting TLS 1.2  (Read 6874 times)

PeterHeintz

  • EA User
  • **
  • Posts: 967
  • Karma: +58/-18
    • View Profile
Our IT updated our firewall to TLS version 1.2. I am using 'Microsoft OLE DB Driver for SQL Server' which is depreciated by Microsoft since 2005 and supporting TLS V1.0 only. What MSSQL diver supporting TLS 1.2 can I use instead?
I tried the MSSQL native driver V11 but I did not get it to work.
Best regards,

Peter Heintz

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13381
  • Karma: +563/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: 'Microsoft OLE DB Driver for SQL Server' is not supporting TLS 1.2
« Reply #1 on: October 02, 2020, 09:12:17 pm »
The native driver works; we have used it in the past.

But I do remember there being an issue that he wouldn't save the same of the connection.
We where able to work around that by first creating the connection use the old OLEDB driver, saving the connection as shortcut, and then in the shortcut file update the connectionstring to be using the native driver instead of the OLE DB driver. (I don't remember the exact name, but that should be a google away)

Geert

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8074
  • Karma: +118/-20
    • View Profile
Re: 'Microsoft OLE DB Driver for SQL Server' is not supporting TLS 1.2
« Reply #2 on: October 05, 2020, 09:01:59 am »
https://www.sparxsystems.com/enterprise_architect_user_guide/15.2/model_repository/connecttosqlserver.html

Quote
'Microsoft OLE DB Driver for SQL Server' is a newly released driver that adds support for TLS v1.2 and other more recent features of Microsoft SQL Server (such as multi-subnet failover capabilities); this driver is available from the Microsoft website

PeterHeintz

  • EA User
  • **
  • Posts: 967
  • Karma: +58/-18
    • View Profile
Re: 'Microsoft OLE DB Driver for SQL Server' is not supporting TLS 1.2
« Reply #3 on: October 08, 2020, 12:19:37 am »
At a first place I found information that Microsoft will not update those drivers to TLS 1.2. But now I saw that Microsoft changed there mind and newer OLE MSSQL version supporting TLS1.2 are available. So this is solved!
Best regards,

Peter Heintz