Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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