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.

I'm receiving the exact same errors when attempting to connect to my company's gallery connection. Any help is appreciated.

 

Best,

Labels