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

Product Family	Product	System	SAS Release
			Reported	Fixed*
SAS System	SAS/ACCESS Interface to Microsoft SQL Server	64-bit Enabled AIX	9.4 TS1M6
		64-bit Enabled Solaris	9.4 TS1M6
		HP-UX IPF	9.4 TS1M6
		Linux for x64	9.4 TS1M6
		Solaris for x64	9.4 TS1M6

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

---

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

When you use NT Lan Manager (NTLM) authentication with SAS/ACCESS Interface to Microsoft SQL, the following error occurs: "Unable to dynamically load client DLL libS0ssl27.so."

Type:	Problem Note
Priority:	high
Topic:	Data Management ==> Data Sources ==> External Databases ==> MS SQL Server

Date Modified:	2019-02-07 10:13:05
Date Created:	2019-01-24 10:19:46