Data source name not found and no default driver specified

[yraja]

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 solution]

Try following the steps here:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Data-source-name-not-found-and-no-d...

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

[yraja]

Thanks @echuong1 🙂

It worked, after I change the System setting 'Run As' credentials to the specific user who have access to database server.