Problem Note 67590: The Kerberos connection to Greenplum from SAS® Federation Server fails with "CLI error trying to establish connection..." if you use the UID option
 |  |  |  |  |
The connection to Greenplum from SAS® Federation Server 4.4 fails when you try to use a Kerberos connection and include the UID option in the connection string. In this scenario, if you use a LIBNAME statement, an error similar to the following appears in the log:
libname x fedsvr noprompt="driver=remts;server=server;port=24142;sspi=1;secpackagelist=kerberos;conopts=(dsn=greenplum_sso;uid=sldtest;)";
ERROR: CLI error trying to establish connection: Unable to establish
connection : ERROR: [SAS][ODBC Greenplum Wire Protocol driver]Socket
closed. : ERROR: [SAS][ODBC Greenplum Wire Protocol driver]Socket
closed
ERROR: Error in the LIBNAME statement.
ERROR: CLI error trying to establish connection: Unable to establish
connection : ERROR: [SAS][ODBC Greenplum Wire Protocol driver]Socket
closed. : ERROR: [SAS][ODBC Greenplum Wire Protocol driver]Socket
closed
ERROR: Error in the LIBNAME statement.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Federation Server | Microsoft® Windows® for x64 | 4.4 | 9.4 TS1M7 | 9.4 TS1M7 | |
| 64-bit Enabled AIX | 4.4 | 9.4 TS1M7 | 9.4 TS1M7 | |||
| 64-bit Enabled Solaris | 4.4 | 9.4 TS1M7 | 9.4 TS1M7 | |||
| HP-UX IPF | 4.4 | 9.4 TS1M7 | 9.4 TS1M7 | |||
| Linux for x64 | 4.4 | 9.4 TS1M7 | 9.4 TS1M7 | |||
| Solaris for x64 | 4.4 | 9.4 TS1M7 | 9.4 TS1M7 | |||
A fix for this issue for SAS Threaded Kernel Extensions for FedSQL and DS2 Standalone 9.4_M7 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/J1F.html#67590
Here is the complete error message: "ERROR: CLI error trying to establish connection: Unable to establish connection: ERROR: [SAS][ODBC Greenplum Wire Protocol driver]Socket closed ERROR: Error in the LIBNAME statement."
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2021-05-21 13:34:16 |
| Date Created: | 2021-03-11 22:21:34 |