0

I wan to test the SQL Server database with JMeter but I am not able to figure out how to make the connection. I am using SQLExpress and using the windows type authentication. The below figure shows my SQL Server Authentication method

enter image description here

I am trying to configure JMeter with below configuration

enter image description here

I tried to do this but I am getting the below error

Response message:java.sql.SQLException: Cannot create JDBC driver of class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' for connect URL ' jdbc:sqlserver://219.65.110.50;intanceName=./SQLEXPRESS;Database=Northwind'

And what will be the username and password?

Dale K
  • 25,246
  • 15
  • 42
  • 71
Biswajit Sharma
  • 142
  • 7

1 Answers1

1
  1. Add ;integratedSecurity=true parameter to the end of your JDBC URL
  2. Username and password can be left blank as the authentication will be done by Windows
  3. Make sure that mssql-jdbc_auth-<version>-<arch>.dll file is present in java.library.path
  4. Make sure that mssql-jdbc-<version>.<jre-version.jar is in JMeter Classpath (lib folder of your JMeter installation or in the folder where user.classpath JMeter Property points to)

More information: Connecting with Integrated Authentication

Dmitri T
  • 159,985
  • 5
  • 83
  • 133