Configuring Sterling B2B Integrator for data traffic encryption with SSL authentication in MS SQL

You can enable data traffic encryption and SSL authentication for the MS SQL database for a Windows environment.

Before you begin

If you are using MS SQL 2014, to use TLSv1.2 you must install the latest patch for the Windows OS.

About this task

TLSv1.2 is supported for a Windows environment. This procedure is applicable if you are installing Sterling B2B Integrator using IIM (either using UI or response file).

No additional configurations are required if you are using TLSv1.0 and TLSv1.1.

Procedure

To configure Sterling B2B Integrator for TLSv1.2 for a Windows environment, complete the following steps:

  1. Add the system environment variable to the Windows server where Sterling B2B Integrator is being installed.
    1. Go to Environment Variables > System Variables and click New.
    2. Add variable IBM_JAVA_OPTIONS.
    3. Set variable value to -Dcom.ibm.jsse2.overrideDefaultTLS=true
  2. Install the required version of IBM Installation Manager. For more information, see The IBM Installation Manager (IIM).
  3. Access the IBMIM.ini file located by default in the C:\Program Files\IBM\Installation Manager\eclipse directory.
  4. Add the -Dcom.ibm.jsse2.overrideDefaultTLS=true parameter on a new line just below the -vmargs parameter.
  5. Install Sterling B2B Integrator by using IIM.