6/17/21: We have completed maintenance for the Search functionality on the Community. If you are seeing any issues, please try to clear your cache first. If the issue persists please email Community@alteryx.com

Alteryx Designer Knowledge Base

Definitive answers from Designer 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