community
cancel
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

Highlighted

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:

 

2018-01-19_12-29-02.png

 

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.

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

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