title: Issue creating a connection to SQL server 2014 with ODBC data source and TLS activated
body: <p>I am trying to create / modify a system data source for my application which needs to connect to our Microsoft SQL Express 2014 database through an ODBC data source.
  The connection used to work before we enabled the SSL encryption flow but,
  now that we have an encrypted link, the connection does not work anymore.</p>
  
  <p>Here are some details:</p>
  
  <ul>
  <li>We run Microsoft SQL Server express 2014 SP1 with the latest cumulative update (CU #3) (which was necessary so that we could deactivate SSL 3.0 and TLS 1.0 and run only with TLS 1.1 and TLS 1.2)</li>
  <li>The database instance is a named instance, configured to run with a TCP/IP connection and a fixed port.</li>
  <li>We enabled the "Force Encryption" option and configured the certificate through the "Sql Server Configuration Manager"</li>
  <li>We can successfully establish a connection to the database either using Management Studio or the SQL command line utility</li>
  <li>We disabled all usage of SSL/TLS prior to version TLS 1.1 done through Microsoft Schannel. This required us to update SQL Express 2014 SP1 to the latest cumulative update (CU #3)</li>
  <li>The ODBC data source we try to configure (through ODBC data source Administrator) is a "System DSN" and uses the "SQL server" driver and target the exact same server name as the one working in management studio (and whose server name corresponds to the machine FQDN which is reflected in the certificate CN value)</li>
  <li>The Version indicated for the SQL Server ODBC driver is "Microsoft SQL Server ODBC Driver Version 06.03.9600"</li>
  <li>I am testing the connection directly through the ODBC data source Administrator tool.</li>
  <li>The first test I runs are run on the exact same machine as the one hosting the database server.</li>
  </ul>
  
  <p>We get two consecutive error message in the Microsoft SQL Server Login:</p>
  
  <pre><code>Connection failed:
  SQLState : '01000'
  SQL Server Error: 771
  [Microsoft][ODBC SQL Server Driver][TCP/IP  Sockets]ConnectionOpen(SECDoClientHandshake()).
  Connection failed:
  SQLState : '08001'
  SQL Server Error: 18
  [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SSL Security error.
  </code></pre>
  
  <p>I went through all the literature I could find but cannot find a solution.</p>
  
  <p><strong>EDIT 27/01/2016 16:30</strong></p>
  
  <p>Following erg suggestion, I tried to use the last MS SQL Server Native Client version (11.00.2100 on my system), but it still does not resolve the issue. I experience another issue though (whether or not I force the strong encryption on the client side results in the same error):</p>
  
  <pre><code>Running connectivity tests...
  
  Attempting connection
  [Microsoft][SQL Server Native Client 11.0]TCP Provider: An existing connection was forcibly closed by the remote host.
  
  [Microsoft][SQL Server Native Client 11.0]Client unable to establish connection
  
  TESTS FAILED!
  </code></pre>