Data Source Name Not Found and no default driver specified

[kedargaikwad]

I ran into an issue while adding a new connection in Alteryx Server and I installed ODBC driver from https://www.microsoft.com/en-us/download/details.aspx?id=56730 with version 18.2.2.0. But the issue still remains the same. Am I doing anything wrong here? I really appreciate the help here.

ODBC driverError message

[joshuaburkhow]

Hi @kedargaikwad 

To start I usually spot check these troubleshooting steps: 

Why did my connection test fail?

• Alteryx Server may not be able to reach the database server host. While logged in to the server on which Alteryx Server is installed, try pinging the database server host to ensure that there is network connectivity.
• The credentials for this database may be invalid or may not have the appropriate permissions. Contact the database administrator.
• The database may be offline. Contact the database administrator to confirm that the database is online and working as expected.
• You may be running a multi-node configuration of Alteryx Server. See Connection tests on a multi-node system

source: https://help.alteryx.com/server/current/admin/Administration/DataConnections.htm#DefaultCredentials

Can you confirm these are good and you still have the issue?