Database connection error ODBC

[sonal]

Trying to connect to the SQL server database on Alteryx server. It throws an error -

ErrorSQLDriverConnect: Microsoft ODBC Driver Manger Data Source Name not found and no default driver specified 

I have verified the host name = server name

Credentials work on SQL Management Studio. Can someone suggest what an I missing?

[rkapoor]

@sonal  this https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Error-SQLDriverconnect-Data-source-nam... may help you.

Let me know how it goes.

[raychase]

Sounds like you're missing the driver that is being referenced within the connection string.

You might try installing the SQL Server Native Client driver.

[sonal]

I am trying to create this connection on Alteryx server to connect to SQL server database( production server). Where do you suggest installing the driver?

[raychase]

You would need the driver installed locally on the machine that hosts your Alteryx Server, as well as any instances of Alteryx Designer that plan to leverage that connection.