Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003

    Unanswered: SQLAgentCmdExec Account Locked Out Intermittenly

    Hi everyone

    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?

    Much appreciated,

  2. #2
    Join Date
    Aug 2002
    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.
    --Satya SKJ
    Microsoft SQL Server MVP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts