I have a set of scheduled jobs on my MS SQL server 2000 and they were working fine until I changed SA password (using sa_password procedure).

If I change the password back they start to work normally.
If I change the password and then create a new job it does not work either.
I was connected as a trusted user when I created the jobs.

What else should be changed along with the SA password?

Windows 2000 pack 4, MS SQL 2000 pack 3.

Thanks you in advance,

Yuriy.


MS Sql Server LazyDBA home page