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 file from the Downloads page of the Ephesoft Customer Support portal.
  3. Extract the contents of the 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:

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.

Was this article helpful to you? Yes No