Enterprise manager
Go to management
Select Sql Agent
Right click -> properties
Go to tab "connection"
If you've set up sql-agent service to authenticate with sql-server using
sql-server authentication; fix the pwd and you're good to go.

Regards,
Uday
.....................................
Direct: +61-2-98059739
Mobile: +61-401 705907
Email: [Email address protected]

-----Original Message-----
From: Gregorev Yuriy
[mailto:mssqldba-ezmlmshield-x29874604.[Email address protected]
Sent: Tuesday, 29 March 2005 5:28 AM
To: LazyDBA Discussion
Subject: Jobs stoped to work after changing SA password.

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.



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]


MS Sql Server LazyDBA home page