Encrypt Connections Using TLS Protocol
This section describes how to configure Easy Workflow to use the TLS protocol to communicate with the SQL Server database on which the Easy Workflow database is created.
To encrypt the connection between Easy Workflow and SQL Server using TLS 1.2,
- Install the required TLS server certificate on the system where the SQL Server instance is installed. For information about the TLS certificate required for your SQL Server, see the TLS 1.2 support for Microsoft SQL Server article.
- Configure the SQL Server to enable encryption. For information about how to configure the server, see Enable encrypted connections to the Database Engine in Microsoft Documentation. If the SQL Server is configured to force encryption, you do not have to perform steps 3 and 4 in this procedure.
- Install a valid TLS client certificate on the server system where the Easy Workflow service is installed and perform the following steps to configure the Encrypt Connection option for the Easy Workflow service:
- Double-click the IEWF Configuration Tool. The Easy Workflow Service and Database Configuration Tool window is displayed.
- Select Easy Workflow Database Settings. The Easy Workflow Database window is displayed.
- Select Encrypt Connection. Easy Workflow uses TLS 1.2 to communicate with the SQL Server.
Note: If the Easy Workflow service is installed on more than one server system, you must install the TLS client certificate on all the systems and perform steps a, b, and c.
- Distribute the TLS client certificate to all the users who access Easy Workflow using the Process Runner Excel Add-in, and then ensure that each user performs the following steps:
- Install the certificate on their systems.
- Select the Encrypt Connection option in the Options window while configuring the Easy Workflow settings. If the users select this option without installing the TLS client certificate, an error message is displayed to indicate that an issue occurred during the logon even though the connection was successful.