But in MSSQL 2000, this is not the case. After changing the new AD password, the MSSQLSERVER & SQLSERVERAGENT will not be updated and it will give you error message (if you start it from SQL Server Enterprise Manager: Server Group->[Instance]->Management->SQL Server Agent):
"An error 1609 - (The service did not start due to a logon failure) occurred while performing this service operation on the SQLServerAgent service."
If you start it from Services.msc(Go to command prompt, type: "services.msc"), you will get the same logon error:
Due to the login account has changed, now MSSQL and SQL Server Agent cannot identify you correctly anymore, since the password it keeps is the one you saved last time. You must change the password to let it works.
1) Right-click the particular service (MSSQLSERVER or SQLSERVERAGENT).
2) Choose "Properties"
3) Select "Log On" tab.
4) Change the new AD password as shown, that is!