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

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

JayZ1 — Fri, 15 Nov 2024 22:45:47 GMT

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 — Thu, 07 Jul 2022 07:00:09 GMT

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 — Thu, 07 Jul 2022 07:07:21 GMT

I am on Mac

gjeremy1617088143 — Thu, 07 Jul 2022 07:37:19 GMT

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