Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
I am on Mac
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