java.sql.SQLException: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.

[JayZ1]

I am trying to execute a query and am getting this error:

java.sql.SQLException: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.

DB: Microsoft SQL Server

JDBC Provider: Open source JTDS

I was able to use the exact same values db/port/schema/user/pass on Datagrip to connect to the database.

I am using this in my advanced settings:

"Domain=DOMAIN;USENTLMV2=TRUE;ssl=require;ApplicationIntent=ReadOnly"

I have also tried TRUE vs true as well as IntegratedSecurity=false

but no luck still getting this error, has anyone got this?

[gjeremy1617088143]

HI, have you installed the auth.ddl in the win32 or java folder?

you can find it in the jtds.zip

Send me love and Kudos

[JayZ1]

I am on Mac

[gjeremy1617088143 · Accepted solution]

it seems you can have this error message if your account is locked out..

you can check also this stack overflow feed :

https://stackoverflow.com/questions/18603696/trouble-connecting-to-sql-server-login-failed-the-login-is-from-an-untrusted-d

there is a lot of useful answer for this type of error