SSL Security error when opening any ReadSoft Invoices module

Issue

Invoices users receive one of the following SSL Security errors when attempting to open any ReadSoft Invoices module.

"Database cannot be opened (13521,0,0)
[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error."

"Database cannot be opened (13521,0,0)
[DBNETLIB][ConnectionOpen (SECCreateCredentials()).]SSL Security error."

Cause

TLS 1.0 has been disabled, and the use of TLS 1.2 is now required within the customer's network environment and/or SQL Server.

Solution

Support for TLS 1.2 was added in Invoices 6.0 SP2 (6.0.2.0).  All older versions of the Invoices Software prior to this release require TLS 1.0 to be enabled.  
Customers must either enable TLS 1.0 or upgrade to a newer version of the software which provides support for TLS 1.2.
 
Here are the instructions to enable support for TLS 1.2 in Invoices 6.0.2.0 and above:

1. Download & install the Microsoft OLE DB Driver for SQL on all Invoices machines, servers, and the SQL server(s).  At the time of this writing, Version 18 is the latest version released.

Download "Microsoft® OLE DB Driver 18 for SQL Server"
https://www.microsoft.com/en-us/down....aspx?id=56730 

2.  Configure the Invoices Software to use the newer MSOLEDBSQL driver instead of the older SQLOLEDB provider.

• Adjust your Eiglobal.ini file in the Invoices GlobalPath
• Add "MSOLEDBSQL=1" under the [Database] section

Here is some additional information from the Invoices Help File.

===================================
MSOLEDBSQL
Found in: Eiglobal.ini
Section:  [Database]

Description
This flag makes it possible for Kofax ReadSoft Invoices to connect to SQL using MSOLEDBSQL instead of the deprecated version, SQLOLEDB.

Valid values
0 = SQLOLEDB is used to connect to SQL
1 = MSOLEDBSQL is used to connect to SQL
===================================

Level of Complexity 

Advanced

Applies to  

References