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

[PB2527]

Hello All,

I am using Alteryx Designer (non-admin version) + Alteryx Server

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

And the issue occurs when I put the same workflow in Alteryx Server. 

Issue:

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

As per my understanding, I need to change the "Run as" settings in the private gallery but I can't find this (System Settings Option) -> Options --> Advanced Options --> System Settings --> Click "Next" until you see the screen "Run the Worker as a Different User?".  Enter your credentials there in Designer or Server.

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

Looking for resolution on the same.

Thanks in advance.

[danilang]

Hi @PB2527 

Have you created a System ODBC DSN on the server with the same name and connection properties as the DSN that you have on your local machine?

Dan

[dipika07011988]

Installing the odbc driver and SQL server native client 11.0 resolved this issue for me.

Hope this helps you too.