var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: SQLAgentCmdExec Account Locked Out Intermittenly
We have a SQL job that either executes at a scheduled time or we invoke it via an ASP page.
We are having problems with the SQLAgentCmdExec account as from time to time the Job fails with this error message:
"A problem occured while trying to logon to the Windows user SQLAgentCmdExec. The referenced account is currently locked out and may not be logged on to. The step failed."
The funny thing is that after a few tries the job works perfectly using the same account. So, it is intermittent.
Could anyone out there throw some light on this?
What authentication mode you use and make sure the account used has necessary privileges to process?
Also on the NT Level do not set the audit policy to lock out the account after certain period.