Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

Database connection error ODBC

sonal
6 - Meteoroid

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?

 

 

 

4 REPLIES 4
RishiK
Alteryx
Alteryx
raychase
11 - Bolide

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
6 - Meteoroid

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
11 - Bolide

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.