RE: DTS scheduled job failing
Try using sp_password to change the sa account's password by using NULL for the old password. If that doesn't work, try changing yours that way.Otherwise, the MS solution for changing the SA password when you don't have the correct old one is to reinstall.
2004-01-16