This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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
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
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+.
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.