Thank you for reading this question.
The sasadm@saspw account is getting locked frequently. I unlocked it with different Admin user and when it got unlocked, I logged into SAS Management Console with sasadm@saspw. Now, when I am trying to run Importad.SAS script in SAS Enterprise Guide, it is showing error that sasadm@saspw is locked. I checked and the account is locked again. It is happening frequently. Using SAS 9.4, VA 7.3. TS1M3.
Your comments on this will be extremely helpful.
Has the SAS Administrator internal account (sasadm@saspw) password been changed lately? Perhaps you have a component, batch process, or person that is using the old password and needs to be using the new one? Or perhaps the password hasn't been changed and there is a component, batch process, or person using the incorrect password? I would suggest reviewing the SAS Metadata Server log files to look for sasadm@saspw authentication failures to see if you can identity the times, frequency and IP addresses of authentication failures for more clues.
In that case, how was the password changed? Was it done in SAS Management Console User Manager plug-in (which only changes the password), or was it done with SAS Deployment Manager (which changes the password and updates any known/managed uses of it in configuration files and metadata). See the Update a Managed Password section of the SAS 9.4 Intelligence Platform: Security Administration Guide, Second Edition for more info.
Hi @PaulHomes, I first unlocked the sasadm@saspw in SAS Management Console and then ran the Update Password Utility in SAS Deployment Manager, it was showing successful. But when I closed the SAS Management Console and reopened it and tried to use the connection profile sasadm@saspw with changed password, the account was locked again. It's getting locked frequently.
Thanks for your valuable feedback and time.
When you used the SAS Deployment Manager Update Passwords task, did you remember step 3 "Stop all SAS servers and services." and step 4 "Restart the metadata server, the SAS Web Infrastructure database (usually the SAS Web Infrastructure Platform Data Server), and any SAS solution-specific data servers. Do not restart other servers or services." ? If not, then there may have been services using the old password that triggered a lock-out before you got to attempt your SAS MC login. Also, if you have any custom written applications, jobs, or other usages of those credentials they should be shut down or disabled until you have a chance to update them, otherwise they may lock you out by continuing to use the old password.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.