Using SAS/ACCESS^® Interface to Greenplum to connect to an SSL-enabled Greenplum database might result in an intermittent connection failure, similar to this:

libname mygp greenplm server="greenplum.server.com" port=5432 database="test" user="gpuser" password=XXXX 
schema=public conopts="EncryptionMethod=1;ValidateServerCertificate=0";

ERROR: CLI error trying to establish connection: [SAS][ODBC Greenplum Wire Protocol driver]SSL Handshake
Failure reason [Unknown SSL Error].

ERROR: Error in the LIBNAME statement.

When the SSL handshake is performed, a lack of entropy might exist, causing the handshake to be delayed. That delay, in turn, causes the error.

To prevent this issue, do one of the following:

• Add the following statement in the CONOPTS= option in your LIBNAME statement:

  libname mygp greenplm server="greenplum.server.com" port=5432 database="test" user="gpuser" password=XXXX schema=public
   conopts="EncryptionMethod=1;ValidateServerCertificate=0;SeedBeforeConnect=1";

• In Linux and UNIX operating environments, add the following to your data source name (DSN) entry in the odbc.ini file:

  [Greenplum_DB]
  Driver=/sasinstall/AccessClients/9.4/Greenplum/lib/S0gplm27.so
  Description=SAS ACCESS to Greenplum
  ...
  SeedBeforeConnect=1

• Under Windows, modify your ODBC data source to look like this:

Operating System and Release Information