I have set up all my thread groups,jdbc config connection and jdbc request correctly along with all the required jar files in the same folder where apache jmeter is installed but I am not sure why I keep getting the below response in the View Results Tree when I try running a simple SQL command. I have googled so much on internet but I couldn't find any resolution for this error. Could somebody who has JMeter expertise help me in solving this problem. Thank you so much in advance.
Response message: java.sql.SQLException: Cannot create JDBC driver of class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' for connect URL ':jdbc:sqlserver://SDGRD-20\SQL2016:59954;databaseName=AIRProject'
Database URL: :jdbc:sqlserver://ABC\SQL2016:59954;databaseName=Mydatabasename
JDBC Driver class: com.microsoft.sqlserver.jdbc.SQLServerDriver
Remove extra :
connect URL 'jdbc:sqlserver://SDGRD-20\SQL2016:59954;databaseName=AIRProject'