Microsoft SQL Server connection - Windows Authentication

[angel0v89]

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.

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

[dougperez]

Try to put your domain into the user field

DOMAIN\USERNAME

or 

.\USERNAME

[angel0v89]

Where I should add this?

[memphis_data]

Did you figure this out?