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

Question

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

• Downloaded the SQL Server JDBC package for x64 and installed mssql-jdbc-9.4.1.jre8.jar in JMETER_PATH\lib.
• Installed mssql-jdbc_auth-9.4.1.x86.dll in JMETER_PATH\lib, too, but, as advised on the Blazemeter comments, I also installed it in C:\windows\system32, since it is on my java.library.path.
• Restarted JMeter.

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

Answer 1

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

   

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