Its a JMeter Issue while making JDBC Connection

0
votes

Steps done for JDBC Connection are: 1) Thread > JDBC Request > JDBC Connection configuration. 2) Settings under JDBC Connection Configuration are jdbc:sqlserver://localhost:1433;databaseName=sa;integratedSecurity=true username : SA password : abc JDBC Driver : com.microsoft.sqlserver.jdbc.SQLServerDriver

Placed the JDBC Driver in bin folder where JMeter is present. also the dll files are placed in C:\program files\java and C:\Program Files (x86)\Java\jre1.8.0_131\bin

The error shown is "Cannot create PoolableConnectionFactory (This driver is not configured for integrated authentication.)" Please help in resolving this issue. TIA

2
sql-serverjdbcjmeterjmeter-plugins
Remove ;integratedSecurity=true as you seem to want to use SQL authentication, and not integrated authentication. Otherwise see docs.microsoft.com/en-us/sql/connect/jdbc/… - Mark Rotteveel
@MarkRotteveel: It worked. Thank you :) - Kapil Bisht

2 Answers

1
votes

You need to add sqljdbc_auth.dll somewhere to java.library.path and restart JMeter to pick the .dll up.

The sqljdbc_auth.dll file lives under auth folder of the Microsoft JDBC Driver for SQL Server bundle.

As soon as you will have it under your java.library.path your problem should go away.

See The Real Secret to Building a Database Test Plan With JMeter article to learn more about database testing using JMeter

-1
votes

With the Help of @MarkRotteveel this problem has been solved. I removed the ;integratedSecurity=true from Database URL.