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:

• Alteryx Designer
  • All versions
• SQL Server
  • All versions
• Ole DB

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

• SQL Server Native Client 11 Download

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 '.