This page describes how to configure and connect to Microsoft SQL Server over an SSL connection. Perform the following steps:
- Stop Ephesoft Transact.
- Download the jtds-1.3.1.zip file from the Downloads page of the Ephesoft Customer Support portal.
- Extract the contents of the jtds-1.3.1.zip file to a temporary location.
JavaAppServer Changes
- Go to [Ephesoft_Directory]\JavaAppServer\lib.
- Backup and delete the existing jtds-*.jar files.
- Copy the extracted jtds-1.3.1.jar to the lib folder.
- Open EphesoftTransact.exe as an administrator. This executable is located at [Ephesoft_Directory]\JavaAppServer\bin.
- Select the Java tab.
- Add the following parameter to the Java Options field:
Djsse.enableCBCProtection=false
Application Changes
- Go to [Ephesoft_Directory]\Application\WEB-INF\lib.
- Repeat steps 5–6.
Server XML Changes
- Backup the existing server.xml file, located at [Ephesoft_Directory]\JavaAppServer\conf.
- Open the server.xml with an editor.
- 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
- 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.