Error SQLDriverConnect

Question

Hi Experts,

A workflow can be executed by a user from Alteryx Designer on his own computer. However, he gets an error note from Alteryx Gallery regarding database access to Azure (screenshots attached).

He believes that the driver's lack of installation is the cause of the issue.

Should I install the same driver (ODBC Driver 18 for SQL Server) on the Alteryx Server as an Alteryx administrator in order to resolve the problem the customer is having?

Please help.

Data Sources.png

Error from Alteryx Gallery.png

apathetichell · Answer

Your user is correct.

thisceci · Answer

"data source name not found" error means the user created a new DSN from their ODBC (driver + connection) local machine so you would just need to repeat how they did that and apply in server.