Database connection error ODBC

Question

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?

Error Alteryx.PNG

raychase · Answer

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.

sonal · Answer

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 · Answer

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.