Agent jobs fail on "sa" account

  • I have a couple of SQL Server Agent jobs configured to run as "sa"
    However, they fail with the error "Description: The Execute method on the task returned error code 0x80131904 (Login failed for user 'sa'.)."

    Does SQL Server save a password with a job  (e.g. if it is using an old password for the "sa" account) ?  I can't find any setting in the Job Properties about the password for the account.

  • Duplicate post please see here

    ...

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply