...

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 that is bundled (Microsoft JDBC Driver 12.2.0.jre11) with the SQL Server Snap Pack. 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.

• If you are ready to migrate now, go to Migrate jTDS driver to SQL Server driver

...

Basic authentication

To migrate the jTDS driver to the SQL Server driver for Basic authentication or to resolve the jTDS driver issue, remove the jTDS driver and driver class from the JDBC Driver and JDBC Driver Class fields and use the default driver bundled with the SQL Server Snap Pack as shown below:

...

...

• .

• If you are not ready to migrate, go to Switching to an Older Snap Pack Version.

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

...

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.

...

Migrate jTDS driver to SQL Server driver

Basic authentication

To migrate the jTDS driver to the SQL Server driver for Basic authentication or to resolve the jTDS driver issue, remove the jTDS driver and driver class from the JDBC Driver and JDBC Driver Class fields and use the default driver bundled with the SQL Server Snap Pack as shown below:

...

NTLM authentication

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

...