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
or
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
Qlik Replicate
2022.5
Related Content
Welcome to the Qlik Replicate online help
