Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Issues Connecting to SQL Server


Here is the following situation.


I have a database on a SQL Server that I need to query as part of a workflow

I can log into the SQL Server using Microsoft Management Studio and query the database directly

When I try to connect to the SQL Server database in Alteryx - I am getting the following error:




I can connect to other SQL SERVERS without an issue but am unable to connect to the one I need for this workflow.

I've verified my login settings, roles etc (I'm a dbo on the particular db I need to query).


I don't know where to start troubleshooting this.  Any assistance would be greatly appreciated.

Alteryx Certified Partner
Alteryx Certified Partner

For your input try this:


odbc:DRIVE={SQL Server Native Client 11.0};DATABASE=<database>;SERVER=<server>;UID=<userid>;PWD=<password>;

replace the <value> with the configuration values for your connection.


This is a DSN-Less connection string that should work for you.




Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.