SUPPORT / SAMPLES & SAS NOTES
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 | |||