Cannot create JDBC driver of class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' using Jmeter

Question

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.

Error :-

 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'

JDBC Connection Config:-

Database URL: :jdbc:sqlserver://ABC\SQL2016:59954;databaseName=Mydatabasename
JDBC Driver class: com.microsoft.sqlserver.jdbc.SQLServerDriver 

Answer 1

Remove extra :

 connect URL 'jdbc:sqlserver://SDGRD-20\SQL2016:59954;databaseName=AIRProject'