Post reply

SQL Server 2005 Maintenance Plan Job Fail After "sa" Password Change

  • March 12, 2009 at 7:07 am

    #384114

    I created a few Maintenance Plan jobs using the "sa" account for authentication. The "sa" account password was changed since then and these jobs are now failing due to authentication failure. I do not know what the "sa" password was when these jobs were created, so I can changed the "sa" password back to what it was. How can I get these jobs that are failing to use the current "sa" password?

    Thanks

  • March 12, 2009 at 10:34 am

    #958494

    As a followup to this. I can't delete these tasks either, because the deletion process requires "sa"

    authentication as well.

  • March 12, 2009 at 10:42 am

    #958503

    Can't you edit the jobs and re-enter the sa password?


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • March 12, 2009 at 1:14 pm

    #958656

    I tried, but maybe I am doing it wrong. Can you please provide the steps for doing so.

Viewing 4 posts - 1 through 3 (of 3 total)

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