Transact

  1. Home
  2. Transact
  3. System Configuration
  4. Database
  5. Connecting to MSSQL database over SSL

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.

Tags ,
Was this article helpful to you? Yes No