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
;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