jdbcjmetermssql-jdbcintegrated-security

JMeter, MSSQL, JDBC, and Integrated Security with sqljdbc_auth.dll


Notwithstanding this question, I still have not determined the error in my configuration causing the JMeter JDBC sampler to reject integrated security.

Still getting the error in the Response:

Cannot create PoolableConnectionFactory (This driver is not configured for integrated authentication. ClientConnectionId:9c225a40-362d-4aba-8339-cfab9270048f)

JMeter version is 5.4.1.

Updating with screenshot showing os.arch, java.library.path, and placement of the DLL. Database URL: jdbc:sqlserver://myservername:1433;integratedSecurity=true

enter image description here


Solution

    1. Add a Debug Sampler to your Test Plan and configure it like:

      enter image description here

    2. Look for os.arch property, it should be amd64 or x86_64, if it isn't - geta 64-bit Java SDK

    3. Look for java.library.path property, copy the mssql-jdbc_auth-9.4.1.x64.dll library to one of the folders which are in the java.library.path

    4. Restart JMeter to pick up the .dll

    5. Make sure that integratedSecurity=true stanza is in your JDBC URL like

      jdbc:sqlserver://somehost:1433;integratedSecurity=true