Migrate jTDS Driver to SQL Server Driver

Overview

As of main25112, the SQL Server Snap Pack no longer supports the jTDS driver with Basic Authentication. If you are using 2014 and higher SQL Server driver versions, we recommend you use the driver bundled with the SQL Server Snap Pack (Microsoft JDBC Driver 12.2.0.jre11). Note that the older SQL Server versions are supported as is.

In this article, we provide a step-by-step guide for you to mitigate the impact to your pipelines.

Switch to an Older Snap Pack Version

If you need more time to migrate to a SQL Server JDBC driver, switch the SQL Snap Pack version to main23721 to continue to use the jTDS driver. Once you are ready to migrate follow the recommendation provided above.

To switch the SQL Snap Pack version to main23721:

  1. Navigate to SnapLogic® Manager.

  2. Click Snap Packs in the left navigation pane.
    You can view the Snap Packs and their versions.

  3. On the Version dropdown list, select main23721 or a lower version.

  4. Click Update to confirm the upgrade. Learn more about the Snap Pack Versions by Release.

sql-server-sp-version-update.gif

Migrate jTDS driver to SQL Server driver

Once you’re ready to migrate, complete the following steps depending on the type of authentication your account uses.

Basic authentication

To migrate the jTDS driver to the SQL Server driver for Basic authentication or to resolve the jTDS driver issue:

  1. Remove the jTDS driver and driver class from the JDBC Driver and JDBC Driver Class fields.

  2. Use the default driver bundled with the SQL Server Snap Pack as shown below:

jdbc-bundled-driver.png

If you have configured any URL properties specific to jTDS driver, remove those properties from the Url properties field set.

NTLM authentication

To migrate the jTDS Driver to the SQL Server Driver for NTLM authentication, you must do the following reconfiguration:

  1. Remove the jTDS driver from the JDBC Driver Class field and replace it with com.microsoft.sqlserver.jdbc.SQLServerDriver.

  2. Remove useNTLMv2 parameter from the Url properties.

  3. Add the following two new parameters to the Url property name and value fields.
    integratedSecurity=true
    authenticationScheme=NTLM

Â