MS SQL Server speaks versions 7.0 - 7.4 of the TDS (Tabular Data Stream) protocol.
#Sql server client tls ssl error windows#
An MS SQL Server 2014 database is running on a Windows system named db.Assumptionsįor the purposes of this tutorial, the following assumptions are made: This is just as well though, as there is also no obvious way to configure FreeTDS to use a private key and certificate on the client-side. Unfortunately MS SQL Server doesn't support mutual authentication via TLS/SSL that is, the database cannot validate the application's certficate and common name.
This tutorial walks through enabling TLS/SSL encryption between a FreeTDS application and an Microsoft SQL Server 2014 database, including basic encryption, certificate validation, and common name validation.