SQL Server Agent jobs fail to run since changing the 'sa' password

• dominicl

  Grasshopper

  Points: 10

  More actions

  August 13, 2008 at 11:13 am

  #154612

  Hi,

  We have changed our 'sa' password and since doing so, none of the jobs that use that account will run. The error_log shows errors like this from the scheduled task:

  2008-08-13 03:30:00.46 Logon Error: 18456, Severity: 14, State: 16.

  2008-08-13 03:30:00.46 Logon Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: ]

  And when I try to set the login for the task to 'sa' with the new password and run the job manually, I get this:

  2008-08-13 09:04:35.86 Logon Error: 18456, Severity: 14, State: 8.

  2008-08-13 09:04:35.86 Logon Login failed for user 'sa'. [CLIENT: ]

  I have been going in to the job, in to the steps and editing the step setting authentication to SQL server and giving it 'sa'. Every time I go back in, it has switched back to 'Use Windows Auth'. For what it's worth, I'm logged in to SQL server mgmt studio as 'sa' and not a domain account.

  TIA

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  August 13, 2008 at 2:29 pm

  #857718

  Did you restart your SQL Agent?

• dominicl

  Grasshopper

  Points: 10

  More actions

  August 13, 2008 at 4:14 pm

  #857767

  SQL ORACLE (8/13/2008)

  ---

  Did you restart your SQL Agent?

  I tried restarting the SQL Agent service and the problem persists.