Home Forums SQL Server 2005 Administering Maintenance Jobs Fail After Changing sa Password RE: Maintenance Jobs Fail After Changing sa Password

  • September 26, 2012 at 8:06 am

    #1542431

    jamessdba (9/24/2012)

    Hi,

    In one of our servers(sqlserver 2005 ent edi) all maintenance plans(scheduled db backups) running under sa login & pwd

    we have changed the sa password

    now all maintenance jobs are failed

    could you please suggest to solution.

    Yes, in 2005 and newer versions you have to open up each Maint plan and edit the connections and retype in the new password.