The following error might occur when you use NTLM authentication with SAS/ACCESS^® Interface to Microsoft SQL Server:

In an effort to change the way Secure Socket Layer (SSL) dependencies are delivered by SAS^®, the branded libS0ssl27.so file is no longer shipped with SAS/ACCESS Interface to Microsoft SQL Server. However, the Progress DataDirect SQL Server driver that is shipped with this product still requires that library for NTLM authentication even if an SSL connection is not required.

To correct this problem, click the Downloads tab in this note to access and install the missing file.

Progress DataDirect is considering an enhancement for this driver that does not require this library to be present for NTLM authentication. However, currently, if you want to use NTLM with SQL Server, you need to download the libS0ssl27.so driver and place it into the appropriate directory, as shown below:

For SAS^® 9.4M6 (TS1M6):

For SAS^® Viya 3.4^®, you can place the file in either or both of these directories, if they exist:

Operating System and Release Information

To access and install the file that is needed to resolve the issue that is described in this note, click the following link: ftp.sas.com/techsup/download/hotfix/datadirect_NTLM.html