Driver version or jar name

6.4.0.jre8

SQL Server version

SQL Server 2017

Client operating system

Windows 10

Java/JVM version

Oracle Java 8 1.8.0_144

Table schema

N/A

Problem description

Our application currently utilizes jTDS to communicate with SQL Server databases. We
would like to switch to the Microsoft JDBC driver, for a few reasons:

• jTDS does not support using an application-provided trust store for TLS connections
• jTDS does not support advanced SQL Server features
• jTDS is not in active development
• jTDS does not support integrated authentication

The problem we're having is that the Microsoft driver doesn't seem to offer one of the
authentication modes that our application relies on heavily: the ability to log into
the database as an arbitrary domain user.

Please see the JavaDoc comments in the reproduction code for details.

And of course, there's always the case that I'm doing something wrong.

Expected behavior and actual behavior

I've written a really simple test case. See "Repro code" below.

Expected behavior: "PASS"
Actual behavior: "FAIL" with an error that user '' failed to log in.

Repro code

Please see the Java class for an A/B example of what we currently do with the jTDS
driver that I've been unsuccessful in getting to work with the Microsoft driver.

https://github.com/NathanStrong-Tripwire/mssql-jdbc-usecase