JTDS Driver

The JTDS driver provides connections for MSSQL databases.

To install the JDBC driver:

Download the JTDS.zip archive.
For other drivers, see the list of supported drivers.
Extract the ZIP file.
Copy the jtds-x.x.x.jar file to the bin/ext folder of your ReadyAPI installation.
Note
You need to restart ReadyAPI upon installing a .jar file.

Connection String Template

To authenticate correctly, you need to add a connection string. You can do this in the ReadyAPI Preferences menu.

Click Preferences on the toolbar.
Open the JDBC Drivers settings.
Click .
Enter a descriptive name for the driver.
You can use the following name for now: MSSQL/net.sourceforge.jtds.jdbc.Driver.
A new connection will appear at the end of the list.
Add a connection string template. It should look like this:
```
jdbc:jtds:sqlserver://<HOST:127.0.0.1>:<PORT:1433>/<DB>;domain=
<yourdomain>;trusted_connection=yes
```
Replace <yourdomain> with your domain name. The PORT should be the fixed port you have set up on the server.

To use Windows (NTLM) authorization with JTDS:

Open the extracted JTDS archive.
Open the directory that is appropriate for your operating system: x86 or x64.
Open the SSO directory.
Copy the ntlmauth.dll file and place it the bin folder of your ReadyAPI installation.

If ReadyAPI is running, you need to restart it.