Connecting to MSSQL database over SSL

This page describes how to configure and connect to Microsoft SQL Server over an SSL connection. Perform the following steps:

  1. Stop Ephesoft Transact.
  2. Download the following ZIP file: jtds-1.3.1.zip.
  3. Extract the contents of the jtds-1.3.1.zip file to a temporary location.

JavaAppServer Changes

  1. Go to [Ephesoft_Directory]\JavaAppServer\lib.
  2. Backup and delete the existing jtds-*.jar files.
  3. Copy the extracted jtds-1.3.1.jar to the lib folder.
  4. Open EphesoftTransact.exe as an administrator. This executable is located at [Ephesoft_Directory]\JavaAppServer\bin.
  5. Select the Java tab.
  6. Add the following parameter to the Java Options field:
Djsse.enableCBCProtection=false

Application Changes

  1. Go to [Ephesoft_Directory]\Application\WEB-INF\lib.
  2. Repeat steps 5–6.

Server XML Changes

  1. Backup the existing server.xml file, located at [Ephesoft_Directory]\JavaAppServer\conf.
  2. Open the server.xml with an editor.
  3. Update the following connection string by adding “ssl=require”.
jdbcUrl=”jdbc:jtds:sqlserver://localhost:1433;databaseName=ephesoft;sendStringParametersAsUnicode= true;prepareSQL=3;ssl=require;”

Certificate Import

  1. Import the certificate in the Java Keystore. 

Note: Ensure the database is configured properly for encryption. Refer to the following Microsoft support article: How to Enable SSL Encryption for an Instance of SQL Server by Using Microsoft Management Console.