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
Add a Debug Sampler to your Test Plan and configure it like:
Look for os.arch
property, it should be amd64
or x86_64
, if it isn't - geta 64-bit Java SDK
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
Restart JMeter to pick up the .dll
Make sure that integratedSecurity=true
stanza is in your JDBC URL like
jdbc:sqlserver://somehost:1433;integratedSecurity=true