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: 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:
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.
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:
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 | |||
Viya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdatesA fix for this issue for DataDirect ODBC Driver for Microsoft SQL Server 9.44 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/J2Y.html#66966| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2023-03-21 08:04:40 |
| Date Created: | 2020-11-18 14:00:59 |