Forum Discussion

mamar's avatar
mamar
Contributor
12 years ago

JDBC error - SoapUI Pro 4.5.2 with MSSQL Server 2012 Express

Hi,
I am having SoapUI 4.5.2 Pro installed and having MS SQL Server 2012 Express. I am trying to connect soapui with my local database with JDBC test step with below details, but always getting a error. Details are below.

com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc:sqlserver://<localhost_ip>;databaseName=MyDB;integratedSecurity=true;


com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host <localhost_ip>, port 1433 has failed. Error: "Connection refused: connect. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".

could anyone help me on this?

2 Replies

  • Are you trying to use the jTDS driver for this? Do you have the driver in SoapUI's "bin/ext" directory? There should also be a DLL that you would place in the "bin" directory.

    Can you confirm on all that setup?

    Thanks,
    Michael Giller
    SmartBear Software
  • I used JTDS driver and was able to connect SQL.

    Thanks