Usage Note 61519: The "...SSL Handshake Failure..." error occurs when you use SAS/ACCESS® Interface to Microsoft SQL Server on UNIX systems
 |  |  |  |
When using SAS/ACCESS Interface to Microsoft SQL Server to connect to a SQL Server database, you can receive the following error:
ERROR: CLI error trying to establish connection: [SAS][ODBC SQL Server Wire Protocol driver]Socket closed. : [SAS][ODBC SQL Server
Wire Protocol driver]SSL Handshake Failure reason [Unknown SSL Error].
Wire Protocol driver]SSL Handshake Failure reason [Unknown SSL Error].
The problem often occurs intermittently.
The error occurs when the SQL Server driver attempts to connect to the SQL Server database, but does not connect in time.
To circumvent the problem, change the ConnectionRetryCount parameter from 0 to a higher number such as 4 in your odbc.ini file. You can also increase the ConnectionRetryDelay parameter to allow more time in between each connection attempt. Sometimes, increasing the LoginTimeout parameter can help as well.
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 | 64-bit Enabled AIX | 9.4 | 9.4 TS1M0 | ||
| 64-bit Enabled Solaris | 9.4 | 9.4 TS1M0 | ||||
| HP-UX IPF | 9.4 | 9.4 TS1M0 | ||||
| Linux for x64 | 9.4 | 9.4 TS1M0 | ||||
| Solaris for x64 | 9.4 | 9.4 TS1M0 | ||||
The "Socket closed...SSL Handshake Failure..." error can occur when using SAS/ACCESS Interface to Microsoft SQL Server. The problem occurs when the SQL Server driver attempts to connect, but times out. To circumvent the problem, increase the ConnectionRetryCount parameter in your odbc.ini file.
| Type: | Usage Note |
| Priority: |
| Date Modified: | 2018-01-01 09:38:30 |
| Date Created: | 2017-12-06 11:27:54 |