Hello Alteryx Community
I am having difficulty connecting Alteryx to a template that requires a Database Alias. Here are some of the errors I am receiving, any thoughts on things to check/troubleshoot would be awesome.I am able to connect each input data tool manually to the SQL database via the connection manager, however setting up the automatic connection via a database alias is not connecting. I have tried both running the Driver 17 version and Driver 18 version. They had different errors as listed below:
Driver 18
Internal Error SQLDriverConnect: [Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: The certificate chain was issued by an authority that is not trusted. [Microsoft][ODBC Driver 18 for SQL Server]Client unable to establish connection.]
Driver 17
DbFileInput (1): Unable to transalte alias
DbFileInput (1): Workflow was Cancelled by Properties Settings
Any thoughts on these errors would be much appreciated!
Thanks!
