Alteryx Designer Desktop Discussions

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

Microsoft SQL Server connection - Windows Authentication

angel0v89
7 - Meteor

Hi all, 

 

I am currently connecting to our Microsoft SQL Server via SSMS using Windows Authentication. When I try to connect Alteryx to it, using the Windows Authentication, I have got the following error: 

 

Get Table List Error: Error SQLDriverConnect: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication.

 

angel0v89_0-1631095932097.png

 

However, if I use another user with a SQL Authentication, then it works! Can you please help me to fix the Windows Authentication one as I have got more permissions with that user.

 

Alex

 

 

2 REPLIES 2
dougperez
12 - Quasar

Try to put your domain into the user field

DOMAIN\USERNAME

or 

.\USERNAME

angel0v89
7 - Meteor

Where I should add this?

Labels