By default, Stonefield Query uses the standard SQL Server ODBC driver to connect to SQL Server databases. This driver is able to connect to most SQL Server configurations. However, it does not support the TLS 1.2 security option, so Query's attempts to connect to databases with this option enabled will fail. Such a failed connection will include SSL Security Error as a part of the failure message.

Another ODBC driver, SQL Server Native Client 11.0, does support TLS 1.2. If Stonefield Query encounters the SSL error, it will check to see whether this alternate driver is installed. If it is, Query will automatically attempt to connect using this driver instead. If not, a connection failure message will be displayed, explaining the SSL error. There are several options for resolving this error.

  1. Turn off TLS 1.2 on the SQL Server instance.
  2. Install the SQL Server Native Client 11.0 driver from Microsoft. This download can be located by a web search of sql server native client 11.0 download.
  3. Use another TLS 1.2-compliant ODBC driver in Query. An alternate driver can be specified using the ServerType= setting in data.ini. The full instructions for this are given in the Specifying the ODBC driver section of the ini settings topic.

© Stonefield Software Inc., 1996-2021 • Updated: 01/27/21
Comment or report problem with topic