SUPPORT / SAMPLES & SAS NOTES
Problem Note 66966: The error "Unable to dynamically load client DLL libS0ssl28.so..." might occur when you connect to Microsoft SQL Server and use NTLM authentication
 |  |  |  |  |
When connecting to SQL Server using SAS/ACCESS® Interface to Microsoft SQL and NTLM authentication, you might receive the following error:
ERROR: CLI error trying to establish connection: [SAS][ODBC SQL Server Wire Protocol driver]Unable to dynamically load client DLL libS0ssl28.so. : [SAS][ODBC SQL Server Wire Protocol driver]SSL Initialization failure.
ERROR: Error in the LIBNAME statement.
ERROR: Error in the LIBNAME statement.
Click the Hot Fix tab in this note to access the hot fix for this issue.
After applying the hot fix, you must add the following options to your ODBC dsn. If you use SAS®9.4, you can use the following options. Note: You must change <SASROOT> to be the location of your SAS install:
CryptoProtocolVersion=TLSv1.2, TLSv1.1,TLSv1, SSLv3, SSLv2
EncryptionMethod=1
CryptoLibName=<SASROOT>/SASFoundation/9.4/sasexe/libcrypto.so
SSLLibName=<SASROOT>/SASFoundation/9.4/sasexe/libssl.so
EncryptionMethod=1
CryptoLibName=<SASROOT>/SASFoundation/9.4/sasexe/libcrypto.so
SSLLibName=<SASROOT>/SASFoundation/9.4/sasexe/libssl.so
If you use SAS® Viya® 3.5, you must use the following options. You must create the libssl.so and libcrypto.so files using OpenSSL.
CryptoProtocolVersion=TLSv1.2, TLSv1.1,TLSv1, SSLv3, SSLv2
EncryptionMethod=1
CryptoLibName=<location of file>/libcrypto.so
SSLLibName=<location of file>/libssl.so
EncryptionMethod=1
CryptoLibName=<location of file>/libcrypto.so
SSLLibName=<location of file>/libssl.so
If you use the SAS® Viya® platform 2020.1 or later, use the following options:
CryptoProtocolVersion=TLSv1.2, TLSv1.1,TLSv1, SSLv3, SSLv2
EncryptionMethod=1
CryptoLibName=/usr/lib64/libcrypto.so
SSLLibName=/usr/lib64/libssl.so
EncryptionMethod=1
CryptoLibName=/usr/lib64/libcrypto.so
SSLLibName=/usr/lib64/libssl.so
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Microsoft SQL Server | Linux for x64 | V.03.05 | 2020.1 | Viya | Viya |
| 64-bit Enabled AIX | 2020.1 | 9.4 TS1M7 | Viya | |||
| 64-bit Enabled Solaris | 2020.1 | 9.4 TS1M7 | Viya | |||
| HP-UX IPF | 2020.1 | 9.4 TS1M7 | Viya | |||
| Solaris for x64 | 2020.1 | 9.4 TS1M7 | Viya | |||