Microsoft JDBC Driver connector compatibility for SQL Server in JMeter Version 5.4.

[Hyzts 09]

I would like to ask for your kind assistance with a problem I am currently experiencing, about which I have not found any information on the internet or in official documentation.

In short this is my case: I am automating in JMeter and it turns out that I have some tests that require connecting to the database and executing statements or scripts. But it turns out that locally I was using a version of Jmeter 5.6.3 and a Microsoft JDBC Driver connector for SQL Server version mssql-jdbc-12.6.2.jre11, it works fine for me. But when running these tests from Continuous Integration (Azure) and in which the Jmeter version is 5.4, I realized that a particular scenario does not work well, because the SQL statement (Delete) is not executed.

 I installed a Java version 8 connector and with this it executes all the tests in Continuous Integration (including the one that was failing), but it turns out that now some scenarios that do not use a database connection fail, checking I found that the requests that fail receive an error code 401  (Unauthorized).

I have tried installing different versions of the Microsoft JDBC Driver connector for SQL Server for Java 8 (which according to what I found out is the SDK version used in continuous integration). But I have not had any luck, that is, the database connection is established correctly and the scripts (SQL statements) are executed, but the tests fail with that 401 error. I have already ruled out that they are indeed authentication issues in the scenarios. In fact, if I launch the scenarios in CI and the connector I use is Java 11, the scenarios that fail because of the 401 this time do pass and the scenarios that use databases pass too, but in one of them the SQL statements are not executed.

I performed the following test: I removed the scenarios that failed with the 401 error when the Java 8 connector was present. It turns out that other scenarios now fail with the same 401 error.

Please confirm if version 5.4 is not compatible with the Microsoft JDBC Driver for SQL Server connector or with certain versions of Java 8 or 11. I've performed several tests, and the problem persists. Could you please confirm if this issue is actually due to JMeter version 5.4 compatibility with the connector, or if it could be something else?

Thank you.

[Dmitri T]

I can confirm the following:

1. You should be using the latest version of JMeter 
2. You should be using JDBC driver which is used by the system under test clients
3. If there are inconsistencies between local and CI executions - analyze request and response details using View Results Tree listener, identify the differences and update JMeter configuration to eliminate them. It might also be a good idea to increase JMeter logging verbosity for the components you're using like JDBC test elements.