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?
@sonal this https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Error-SQLDriverconnect-Data-source-nam... may help you.
Let me know how it goes.
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.
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?
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.