Applies to ReadyAPI 3.2.5, last modified on May 19, 2020

The JTDS driver provides connections for MSSQL databases.

To install the JDBC driver:

  1. Download the JTDS.zip archive.

    For other drivers, see the list of supported drivers.

  2. Extract the ZIP file.

  3. Copy the jtds-x.x.x.jar file to the bin/ext folder of your ReadyAPI installation.

    The JTDS driver in the ReadyAPI installation directory

    Click the image to enlarge it.

    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.

  1. Click Preferences on the toolbar.

    ReadyAPI: Opening the preferences menu from the toolbar

    Click the image to enlarge it.

  2. Open the JDBC Drivers settings.

    ReadyAPI: The JDBC drivers tab in the preferences menu

    Click the image to enlarge it.

  3. Click .

  4. Enter a descriptive name for the driver.

    ReadyAPI: Entering the JDBC connection name

    You can use the following name for now: MSSQL/net.sourceforge.jtds.jdbc.Driver.

  5. A new connection will appear at the end of the list.

    ReadyAPI: The JDBC connections list with the new connection

    Click the image to enlarge it.

  6. 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.

    ReadyAPI: The new JDBC connection with the connection string

    Click the image to enlarge it.

Configuring Windows Authorization

To use Windows (NTLM) authorization with JTDS:

  1. Open the extracted JTDS archive.

  2. Open the directory that is appropriate for your operating system: x86 or x64.

  3. Open the SSO directory.

  4. Copy the ntlmauth.dll file and place it the bin folder of your ReadyAPI installation.

The ntlmauth.dll file in the ReadyAPI installation directory

Click the image to enlarge it.

Note: If ReadyAPI is running, you need to restart it.

See Also

Microsoft SQL JDBC Driver
Installing Database Drivers

Highlight search results