Ok i think I used a wrong option (BL_USE_SSL). My purpose is to enable SSL for SAS app that connects to Amazon Redshift that its SSL is turned on (require_ssl=true). If you have any guidance / example, it is appreciated very much if you can share them. ... View more

without turning on SSL on Redshift server, everything works fine for a long time. ... View more

Sorry for my previous message that code example is not matched with error message. After awhile, i realized that for redshift engine, BL_USE_SSL=1  is not right. It should be BL_USE_SSL=YES. After i made change. I still get error.   Code: libname x redshift server="&rs_server" port=5439 user="&rs_user" password="&rs_pwd" database="xxxx"  BL_USE_SSL=YES  schema="xxxx";   Now i got error: ERROR: CLI error trying to establish connection: [SAS][ODBC Redshift Wire Protocol driver][Redshift]FATAL: no pg_hba.conf entry for host "::ffff: xxxx", user "bms_rwrdmuser", database "xxxx", SSL off(File /home/ec2-user/padb/src/pg/src/backend/libpq/auth.c; Line 477; Routine ClientAuthentication; ) ERROR: Error in the LIBNAME statement.   What does it mean here "no pg_hba.conf entry for host "...ffff: xxxx ..."? looks like something wrong in ClientAuthentication from AWS SDK?   Thanks for your further explanation and help Gary ... View more