sql-serverjdbcjmeterpoolsqljdbc

JMeter - SQL Server - Cannot create PoolableConnectionFactory

JMeter 5.3.0

Trying to use the JDBC Connection Configuration.

Downloaded SQL Server JDBC libraries (sqljdbc8.2.2.0).

enter image description here

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?

Solution

    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: