Post reply

Changing sa password effect maintenance plan

  • March 26, 2008 at 5:47 pm

    #154234

    Guys,

    I've created several maintenance plans to run backups (including cross network) and at some point decided to change sa password.

    As a result maintenance plans stopped working, jobs related to them started failing (jobs unrelated to them continued to function correctly). Attempts to delete those maintenance plans and related jobs have failed. The only solution that worked was to change sa password to old value (it resolved all problems)...

    As far as I remember Microsoft had a problem in that area, but it was related to a scheduler... Is version 9.0.3054 right one to run these days ?

    Thank you, Mike.

  • March 26, 2008 at 8:57 pm

    #794425

    I believe it's the job that fails if sa changes in places.

    You could have set credentials in the maintenance plan to connect as SA, which would be a bad idea. I'd check that.

  • March 27, 2008 at 5:29 pm

    #794950

    Could you be more specific?



    My blog

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

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