Windows 10- Cannot connect to the SQL server

Product Forums Katalon Studio
, ,
1

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 Download - JDBC Driver for SQL Server | Microsoft Docs
  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: _classpath - Notepad 2021-0...
    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 : Project Settings 2021-04-20...

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

2

any reply ?

3

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