Replicate Red Hat 8 SQL Server Source fails TCP Provider: Error code 0x2746

Bill_Steinagle — Thu, 21 Mar 2024 17:53:38 GMT

Replicate 2022.5 fails to connect to SQL Server Source Endpoint when connecting from Red Had Linux 8 using the libmsodbcsql-17.10.so.1.1 or libmsodbcsql-17.6.so.1.1.

Error:

Failed to connect RetCode: SQL_ERROR SqlState: 08001 NativeError: 10054 Message: [Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: Error code 0x2746

Resolution

Update the openssl.conf on the Replicate Server running on the Red Hat Linux 8 environment.

information provided on this defect is given as is at the time of documenting. For up-to-date information, please review the most recent Release Notes with the ID RECOB-6147 for reference.

Workaround:

Go to directory /etc/pki/tls/ on the Linux Replicate Server and backup the openssl.conf file and add the below entries:

You need to add this to the beginning of your config file:

openssl_conf = default_conf

Change the value for openssl_conf to default_conf if the line already exists

and make sure to added these entries

[default_conf]
ssl_conf = ssl_sect
[ssl_sect]
system_default = system_default_sect
[system_default_sect]
MinProtocol = TLSv1.2
CipherString = DEFAULT@SECLEVEL=1

Restart the Linux Server for the changes to take affect

Fix Version:

Replicate 2023 version

Cause

The error with the connection is due to the TLS 1.2 version that is the Red Hat 8 default and the Replicate environment having reference to the TLS 1.1 version.

Environment

2022.5