CODEWITHSUNDEEP
sqljmeter
Kev
Kev

Reputation: 360

JMeter MSSQL connection issue

So I am using the following

Jmeter 5.5
Java 17.0.2
mssql-jdbc-11.2.0.jre18.jar

The jar has been installed to the JMeter/lib folder

In the JMeter JDBC Connection Configuration

Database URL is like this: jdbc:sqlserver://xx-xxxxxxxx;DatabaseName=xxxxxx
JDBC driver class is: com.mircrosoft.sqlserver.jdbc.SQLServerDriver
Username and password are valid

When I run the test all I get is this:

Response message:java.sql.SQLException: Cannot load JDBC driver class 'com.mircrosoft.sqlserver.jdbc.SQLServerDriver'

The SQL Server is version 15.0.4223

Any ideas please

Upvotes: 0

Views: 305

Answers (1)

Dmitri T
Dmitri T

Reputation: 168197

You have a typo, the driver class name should be:

com.microsoft.sqlserver.jdbc.SQLServerDriver

and the Validation Query should be select 1

More information: How to use Different JDBC Drivers

Upvotes: 1

Related Questions