Unable to Connect SQLSERVER DB by using JDBC step

sqljdbc42.jar doesn't seem to work with SoapUI open source version so try removing from the ext folder.

sqljdbc4.jar or sqljdbc41.jar should work.

In my case I didn't copy any JDBC files in the lib folder.

https://community.smartbear.com/t5/SoapUI-Open-Source/Solved-JDBC-Cannot-connect-to-a-MS-SQL-database/td-p/132235/page/2

Thanks for your reply

Have tried with two options

Option 1:

Download jtds-1.3.1.jar
And place it under READYAPI_HOME/bin/ext directory and restart.

Use driver class as : net.sourceforge.jtds.jdbc.Driver

Use connection string as :
jdbc:jtds:sqlserver://${dbServer}:${port}/${dbName};domain=${domain}

Getting error as Can't get the connection for specified properties

java.sql.SQLException:Network error IOException:Connection timed out to connect

Option 2

Copied sqljdbc_auth.dll  in bin folder

Copied sqljdbc42.jar  in ext folder

Used SQL Driver as SQL Driver : com.microsoft.sqlserver.jdbc.SQLServerDriver

Connection String as:jdbc:sqlserver://ServerIP:Port;databaseName=DBName;user=username;password=password

Getting error as Could not get the connection specified properties followed by connection string values

Please can you help me any other options for getting connection successful

Currently I'm using trial version of Ready API2.2.0 version

Thanks!!

In Both the cases

Have used my project DB Name, UserName and Password

FYI.. My DB is hosted in Server it is not running locally

Thanks

Thanks for your help!!

Finally I'm able to make the successful connection

SQL Server DB is running in host environment not in local

Used the below steps

1.Copied

                  bin\ext folder contains sqljdbc41.jar

                  bin folder contains sqljdbc_auth.dll

2. Driver Name as com.microsoft.sqlserver.jdbc.SQLServerDriver

3. Connection String as jdbc:sqlserver://<Instannce Name>;databaseName=<DB Name>;integratedSecurity=true

Thanks!!