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

[milind3889]

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. 

[VDD]

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

[Ksharp]

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

And remoce pw= option in Libname statement.