Overview
Some users may need to encrypt the connection to a DB from Ephesoft Transact. To do so, the jtds driver that Transact uses must be updated.
-
- Download the updated driver from here (http://download.ephesoft.com/Ephesoft_Product/Wiki_links/jtds-1.3.1.zip)
- Extract JAR file to a temporary location
- Stop Ephesoft server
- Go to Ephesoft\JavaAppServer\lib and back up existing driver (jtds*.jar)
- Paste updated jtds-1.3.1.jar in the aforementioned directory
- Go to Ephesoft\Application\WEB-INF\lib and back up existing driver (jtds*.jar)
- Paste updated jtds-1.3.1.jar in the aforementioned directory
- If updating the connection for Ephesoft’s DBs (ephesoft, report, report_archive):
-
- Edit Ephesoft\JavaAppServer\conf\server.xml to add the following to all available connection strings in JNDI resources:
[code]encrypt=true;trustServerCertificate=true;ssl=require[/code]
The complete string should look something like this:
[code]jdbc:jtds:sqlserver://<servername>;databaseName=<databasename>;encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;ssl=require[/code]
-
- Enable SSL under SQL Server Configuration manager
-
- In the Certificate tab, select a certificate
- Go to step 10
-
- If updating the connection from Ephesoft’s Connection Manager:
- Configure the connection normally and then add the following:
[code]encrypt=true;trustServerCertificate=true;ssl=require[/code]
The complete string should look something like this:
[code]jdbc:jtds:sqlserver://<servername>;databaseName=<databasename>;encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;ssl=require[/code]
- Restart the server