August 13, 2008 at 11:13 am
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
August 13, 2008 at 2:29 pm
Did you restart your SQL Agent?
August 13, 2008 at 4:14 pm
SQL ORACLE (8/13/2008)
Did you restart your SQL Agent?
I tried restarting the SQL Agent service and the problem persists.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply