JMeter JDBC Connection issue while running on ALT

Question

I have a requirement for connecting JDBC via JMeter and the setup is implemented on local, and it is working fine, while trying to run my JMeter script via ALT I am getting JDBC connection error: -
java.sql.SQLException: Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver'.

Answer 1

Hi ,

Thanks for reaching out to Microsoft Q&A.

Think your local JMeter jsut test works because the sql server jdbc driver JAR is available locally. But In ALT, that JAR is missing, so JMeter could not load the class com.microsoft.sqlserver.jdbc.SQLServerDriver

1. Download the correct driver from Microsoft: Microsoft JDBC Driver for SQL Server Example file: mssql-jdbc-12.6.0.jre11.jar
2. In ALT, add this JAR as an additional file or test artifact along with your .jmx test. ALT will distribute it to all JMeter engines automatically.
3. Confirm your jdbc configuration in JMeter uses:
   1. Driver class: com.microsoft.sqlserver.jdbc.SQLServerDriver
   2. URL: jdbc:sqlserver://<server>.database.windows.net:1433;databaseName=<dbname>;encrypt=true;
4. Ensure the Azure SQL firewall allows connections from ALT’s IP ranges.

Without the JAR file, ALT’s JMeter instance cannot load the SQL Server driver, causing the SQLException. Uploading the jdbc driver resolves the issue.

Please 'Upvote'(Thumbs-up) and 'Accept' as answer if the reply was helpful. This will be benefitting other community members who face the same issue.