Error

[jsb8]

I'm totally new to Alteryx still trying to learn , what seems to be the problem here ?

Error SQLDriverConnect:MicrosoftODBC Driver Manager Data source name not found and no default driver specified (ToolId: 1)

[gabrielvilella]

Please make sure that you have the proper driver and DNS on your machine to connect to the SQL Server. If you are not sure how to do this, please contact your IT team. Once you have that, you will be able to connect from Alteryx.

https://help.alteryx.com/20223/designer/connect-sql-server-database 

[PanPP]

Hi @jsb8 

I would recommend creating a system DSN on your machine that references the proper SQL connection.

You can create a system DSN connection in the ODBC Data Source Admin window at the windows level. Here you can check to see if the connection is validated before connecting to the SQL Server in Designer.

Hope this helps.