topic Re: ODBC encrypt Password in SAS Programming

ODBC encrypt Password

AZIQ1 — Sat, 05 Mar 2022 02:36:05 GMT

Hi,
I used proc pwencode to generate encrypted password but when trying to use it with ODBC connection to Azure server it's not recognizing it and gives error.
Code is

%let ts_pwd = {SAS003}XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX;

LIBNAME TEST ODBC DATAsrc=‘XXX'

USER="ABC"

PWD= "&ts_pwd"

SCHEMA=ABCXYZ

CURSOR_TYPE=FORWARD_ONLY;

ERROR: Failed to authenticate the user ‘ABC’ in Active Directory (Authentication option is 'ActiveDirectoryPassword'). Error code 0xCAA20003;

state 10 ID3242: The security token could not be authenticated or authorized.

ERROR: Error in the LIBNAME statement.
Any ideas or suggestions please !

Thanks

Re: ODBC encrypt Password

SASKiwi — Sat, 05 Mar 2022 07:02:59 GMT

Does it work correctly unencrypted? Have you tried {SAS001} or {SAS002} encryption? If any of these work but {SAS003} encryption doesn't then a track with SAS Tech Support good be a good idea.

Re: ODBC encrypt Password

AZIQ1 — Sat, 05 Mar 2022 14:31:14 GMT

Yes it does work unencrypted. I used SAS003 encryption.

Or any ideas how can I embed my password in the code so that no one sees my password when they open my program. I cannot save it on my local drive and call the program

Thanks

Re: ODBC encrypt Password

Sajid01 — Sat, 05 Mar 2022 20:02:30 GMT

Hello @AZIQ1
Looks like you want to hide the password.
Create an Authentication domain for the server and store password in the metadata sever.
use the authentication domain in the libname statement.
The statement would be something like this

libname mydblib odbc datasrc=mydatasource Authdomain=myothdomain ;;