Problems connecting to Microsoft SQL Server with TLS 1.2 using the OLE Driver

Question

We recently upgraded some of our&nbsp;Microsoft sql servers to use TLS 1.2. After that, I noticed that I couldn't make a database connection to them anymore.&nbsp;I have a JScript function that handles connecting to the database. It creates an ADO command and uses a connection string to specify what driver to use and how to connect to the database. The error message that keeps coming back is SSL handshake error. The oddest part is that the Microsoft Sql Server Management Studio connects just fine, it's just Test Complete that has problems.&nbsp;Does anyone know if I can switch which driver TestComplete uses to connect to databases? I think part of the problem is that the OLE driver doesn't support TLS 1.2

marsha_r · Answer

The options here may be of some help:
&nbsp;
https://support.smartbear.com/testcomplete/docs/testing-with/advanced/working-with-external-data-sources/databases/index.html

andrewa · Answer

What I ended up doing to fix/get around the problem was set up an ODBC connection. I went into windows and used the ODBC admin, then modified the connection string I was using. That cleared up the problem really well!

Forum Discussion

Problems connecting to Microsoft SQL Server with TLS 1.2 using the OLE Driver

2 Replies

Related Content

I am facing problem while connecting MSSQL connection in Soapui free version.

Cant get JDBC connection to microsoft sqlserver to work

TestComplete can't detect elements in Microsoft WebView2 window

Connection reset

JDBC connection error indicating SSL issue

Recent Discussions

Floating window bleep overlapping window takes longer time (~10 min) to click the button on it.

Test case randomly fails with "parent object was not found"

Does TC have a .within() method similar to Cypress.io?

SessionCreator /Timeout option not firing EventControl_OnTimeout

testcomplete feature Intelligent Quality Add Ons