I can't get sqljdbc to work with username / password AD

Question

I need to connect to a HADR 2012 SQL server using an AD account from Java to Linux.

• Integrated protection is not an option since it works on Linux
• I can’t use the JTDS JDBC driver since it does not support the HADR cluster (multSubnetFailover = true support not supported)

Jtds actually works with usernamen / password and domain connection string parameters, but time is 25% of the time.

So, it looks like I'm stuck with the MS SQL JDBC driver, but I can't get it to work with credentials for username and password only. I am trying to solve this problem without Kerberos

This should be possible (theoretically) since jTDS can do it!

I found that the 6.0 driver has the authentication = ActiveDirectoryPassword property , so it looked very promising, but sql string like

jdbc:sqlserver://server:port;database=DB;authentication=ActiveDirectoryPassword;username=name;password=PASSWORD

even trying DOMAIN\usernamefor username or custom property

Even the documents say that for

using Azure AD primary username and password

but it would just make my life easier.

The error I get is that Login failed for user ''it shows an empty user, but by going through the decompiled code, I can see that the username / password values ​​are being loaded into the variables.

Any solution for this? I accept any AD username and password connection to HADR 2012 SQL Server, which is pure JAVA