JDBC driver for Microsoft SQL server connectivity with Active Directory - Integrated authentication method using Jmeter

1
votes

I need to make JDBC connection using Jmeter to Microsoft SQL server which uses Active Directory - Integrated authentication method to connect to DB. Below are the setting I have done in Jmeter. enter image description here When I ran the Jmeter it shows the below exception

java.sql.SQLException: Cannot create PoolableConnectionFactory (This driver is not configured for integrated authentication.

Kindly let me know is there any setting needs to be modified to overcome this issue.

1
sql-serverauthenticationjdbcjmeter
Add more details about the driver you are using.and show more of your DB configuration – user7294900

1 Answers

1
votes
  1. Download Microsoft JDBC Driver
  2. Copy mssql-jdbc-6.2.2.jre8.jar to JMeter Classpath
  3. Copy sqljdbc_auth.dll from auth\x64 folder to java.library.path or specify java.library.path property to point to this file location using either -D command-line argument or via system.properties file
  4. Restart JMeter to pick the files up
  5. Add integratedSecurity=true line to your JDBC URL

More information: The Real Secret to Building a Database Test Plan With JMeter