Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Knowledge Base

Definitive answers from Designer Desktop experts.

Error: "SSL Security error" after disabling TLS on SQL Server

Suskil
Alteryx
Alteryx
Created

Environment Details


The following error occurs in an Input Data Tool after updating SQL Server to SQL 2019 and disabling TLS 1.0 and 1.1:

Error: Input Data (1): Error opening connect string: Microsoft OLE DB Provider for SQL Server: [DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error.\08001 = 1
 
  • Alteryx Designer
    • All versions
  • SQL Server
    • All versions
  • Ole DB
    • 18.3


Cause


The 'Microsoft OLE DB Provider for SQL Server' driver used in the Input Data tool does not support Transport Layer Security (TLS) version 1.2+.



Resolution


Change the connection to use SQL Server Native Client 11.0, which supports TLS 1.2:

1. From the configuration panel, click on the drop-down arrow.
2. Click 'Data sources' > Microsoft SQL Server > OleDB.
3. Select 'SQL Server Native Client 11.0'.  (See the Additional Resources for the download link, if the driver is not available.)



4. Click 'Next' to configure the connection.
5. Click 'Test Connection' to confirm connection details are correct.
6. Click 'OK'. If the connection is successful the 'Choose Table or Specify Query' popup will be presented.

 

Additional Resources

 
 
Comments
MichaelRook
5 - Atom

SQL Server Native Client 11.0 supports connections to, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 (11.x), SQL Server 2014 (12.x), and Azure SQL Database.

 

Support Policies - SQL Server Native Client | Microsoft Docs

 

'SQL Server Native Client 11.0' does not work with 'SQL Server 2019'.