SAS Encoded password is not accepted by SAS Connection to Amazon Redshift

milind3889 — Wed, 26 Jun 2019 20:53:40 GMT

I am trying to connect Amazon Redshift database by using SAS/ACCESS interface to ODBC

I encoded my redshift password and providing encoded password in libname statement.

libname source odbc 
user="milind" 
password="{SAS005}1244C53A7CA4054EA8318............" 
datasrc="RWE_pharmetrics_DSN" 
schema="public";

But I am getting below CLI error in the log

458
459 libname source odbc user="milind"
459! password=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
459! XXX datasrc="RWE_pharmetrics_DSN" schema="public";
ERROR: CLI error trying to establish connection: [Amazon][Amazon Redshift] (10) Error occurred
while trying to connect: [SQLState 28000] FATAL: password authentication failed for user
"milind"
ERROR: Error in the LIBNAME statement.

When I provide direct password (without encoding), it works well.

Re: SAS Encoded password is not accepted by SAS Connection to Amazon Redshift

VDD — Thu, 27 Jun 2019 00:11:23 GMT

parameter needs to be added in the LIBNAME statement to resolve the issue
CONOPTS="EncryptionMethod=6;ValidateServerCertificate=0"

Re: SAS Encoded password is not accepted by SAS Connection to Amazon Redshift

Ksharp — Thu, 27 Jun 2019 12:31:04 GMT

You can set PW in data source "RWE_pharmetrics_DSN" when set it up .

And remoce pw= option in Libname statement.

topic Re: SAS Encoded password is not accepted by SAS Connection to Amazon Redshift in New SAS User

SAS Encoded password is not accepted by SAS Connection to Amazon Redshift

Re: SAS Encoded password is not accepted by SAS Connection to Amazon Redshift

Re: SAS Encoded password is not accepted by SAS Connection to Amazon Redshift