We have updated one of our SQL servers to SQL 2019 and disabled TLS 1.0 and 1.1 which has caused one of our Alteryx workflows to break. We have an input tool connected the SQL server 2019 via an OleDB connection which throws the following error:
Error: Input Data (1): Error opening connect string: Microsoft OLE DB Provider for SQL Server: [DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error.\08001 = 18
I thought this might be caused by an outdated driver so I installed
Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL):
https://docs.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server?view=sql-server-ver15
on the Alteryx Server but I still get the same error. It seems to run fine locally from designer. Any suggestions?
