Unable to connect sql server database

I followed every step in the following mentioned here https://docs.katalon.com/katalon-studio/docs/connect-to-sql-using-windows-authentication.html but still not able to connect.

I installed on my machine :

  • java jdk 14
  • sql server 2017

Here a screenshot of the error
image

@kazurayam I think you have an answer :smiley:

You wrote

localhost:1434

but the dialog displays it wants

localhost:1433

Mind the IP port.

so it was just to test if it will accept another port but also 1433 not working

Is the database process up and running? It might be down, isn’t it?

Though I do not know MS SQL Server at all.

yes , I’m checking if there’s something wrong in sql configuration

Which IP port the DB process is listening to?


Apart from Katalon, you can check connectivity to SQL Server using telnet in commandline.

@ThanhTo

Looks similar to the following issue:

To connect to SQL Server from another computer, you normally use TCP/IP. If TCP/IP is not enabled, right-click TCP/IP, and then click Enable. If you changed the enabled setting for any protocol, restart the Database Engine. In the left pane select SQL Server Services.

Hi All,

I am able to connect to remote SQL server using SQL Server Management Studio on my machine whereas, when I try the DB connectivity from Katalon Studio, it throws The TCP/IP connection to the host has failed.

Please help.

Regards,
Ram