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

    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,
    Manik

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    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
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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