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

I am trying to configure JMeter with below configuration

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?

CodePudding user response：

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