JMeter - SQL Server - Cannot create PoolableConnectionFactory

Question

JMeter 5.3.0

Trying to use the JDBC Connection Configuration.

Downloaded SQL Server JDBC libraries (sqljdbc8.2.2.0).

• put JAR files in {jmeter}\lib\
• put sqljdbc_auth.dll in {jmeter}\lib\
• also tried idea of using a library path in jmeter.bat as per https://performancebasics.wordpress.com/2016/01/25/setting-up-a-jdbc-sql-server-connection-in-jmeter/

Restarted JMeter

Attempted to run JDBC requests.

Still getting the error:

Response message:java.sql.SQLException: Cannot create PoolableConnectionFactory 
(This driver is not configured for integrated authentication. 
ClientConnectionId:80cad180-02fe-43b3-841d-c1a1f8992607)

What else could I need to check?

Answer 1

1. You need to choose only one .jar which matches your JVM version:

   • mssql-jdbc-8.2.2.jre8.jar - for Java 8
   • mssql-jdbc-8.2.2.jre11.jar - for Java 11
   • mssql-jdbc-8.2.2.jre13.jar - for Java 13

2. You need to choose the right architecture of the mssql-jdbc_auth library

   • mssql-jdbc_auth-8.2.2.x86.dll - for 32-bit JVM
   • mssql-jdbc_auth-8.2.2.x64.dll - for 64-bit JVM

3. You need to put this .dll file somewhere into java.library.path. The property value can be passed either via -D command-line argument like:

   jmeter -Djava.library.path=/path/to/folder/where/mssql-jdbc_auth-8.2.2.xxx.dll
   

   or to make the change permanent you can add the relevant line to system.properties file:

   java.library.path=/path/to/folder/where/mssql-jdbc_auth-8.2.2.xxx.dll
   

   More information:

   • Apache JMeter Properties Customization Guide
   • Connecting with integrated authentication On Windows