Data source name not found and no default driver specified

Question

Hello All,

I am using Alteryx Designer (admin version) + Alteryx Desktop Automation

When I run my workflow (extract data from flat files and load into SQL Server) in designer, it runs smoothly.

And the issue occurs when I put the same workflow in Scheduler.

Issue:

Error SQLDriverConnect: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Note: Already installed, "ODBC Driver 17 for SQL Server"

Looking for resolution on the same.

Thanks in advance.

echuong1 · Accepted Answer

Try following the steps here:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Data-source-name-not-found-and-no-default-driver-specified/ta-p/400402

I'd also suggest setting Run As credentials in your Alteryx System Settings. The workflow will be run using a service account that might not have access as well.

https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/Run-As-Settings/ta-p/17830