Transact

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

Connecting to MSSQL database over SSL

 

Configuring and connecting to the MSSQL database over SSL

 

To configure the MSSQL database over SSL connection:

a. Stop the Ephesoft Transact server.

b. Download the jtds-1.3.1.zip file.

c. Extract jtds-1.3.1.zip into a temporary location.

  • JavaAppServer Changes

d. Go to [Ephesoft_home]\JavaAppServer\lib\* directory.

e. Take backup of any existing jtds-*.jar before deleting the same.

f. Copy extracted jtds-1.3.1.jar to the lib folder.

g. Add the following parameter in ‘Java Options’ inside Java tab after opening EphesoftEnterprise.exe (present inside [Ephesoft_home]\JavaAppServer\bin\): -Djsse.enableCBCProtection=false

  • Application Changes

h. Go to [Ephesoft_home]\Application\WEB-INF\lib\* directory.

i. Take backup of any existing jtds-*.jar before deleting the same.

j. Copy extracted jtds-1.3.1.jar to lib folder.

  • Server XML Changes

k. Take backup of server.xml located in [Ephesoft_home]\JavaAppServer\conf\ directory.

l. Update connection string (Append ssl=require as show below):

jdbcUrl=”jdbc:jtds:sqlserver://localhost:1433;databaseName=ephesoft;sendStringParametersAsUnicode=

true;prepareSQL=3;ssl=require;”

  • Certificate Import

m. Import the certificate in Java key store.

 

Note: Make sure that database is configured properly for encryption

https://support.microsoft.com/en-in/help/316898/how-to-enable-ssl-encryption-for-an-instance-of-sql-server-by-using-microsoft-management-console

 

 

Was this article helpful to you? Yes No