Windows 10- Cannot connect to the SQL server

I am trying to connect to the database on katalon-windows , and this what I have done :
for JDBC 9.2:

  1. downloaded JDBC from here https://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver15
  2. Extracted the file into C:\Program Files\Microsoft JDBC DRIVER 9.2 for SQL Server
  3. Added the following lines to .classpath on my katalon project :
    screenshot: https://share.getcloudapp.com/Koud74r9
    CLASSPATH =.;C:\Program Files\Microsoft JDBC DRIVER 9.2 for SQL Server\sqljdbc_9.2\enu\mssql-jdbc-9.2.1.jre11.jar
    CLASSPATH =.;C:\Program Files\Microsoft JDBC DRIVER 9.2 for SQL Server\sqljdbc_9.2\enu\mssql-jdbc-9.2.1.jre8.jar
    CLASSPATH =.;C:\Program Files\Microsoft JDBC DRIVER 9.2 for SQL Server\sqljdbc_9.2\enu\mssql-jdbc-9.2.1.jre15.jar
  4. On Library management on settings on katalon I added theses jars there too
    screenshot : https://share.getcloudapp.com/geubpgwR

For the database connection :

  1. on project settings - on database , added the following :
    JDBC driver : com.microsoft.sqlserver.jdbc.SQLServerDriver
    Connection URL : jdbc:sqlserver://;databaseName=
    besides that my username & password

Result :
Connection Failed , cannot open the server XYZ requested by login

Please let me know what I have done wrong & what I have missed
thank you

any reply ?

Hey @nkhouri

I recommend you to try excluding the built-in JDBC driver of SQL Server before adding an external driver. See this document.

Jass