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
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.
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 ;;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.