administrator password and sql startup

A reality check please...
After changing the domain administrator password, we are no longer
able to connect to databases on a MS SQL Server 2000 server when
attempting to use ODBC drivers from W2K workstations.
The MSSQLSERVER and SQLSERVERAGENT services both show DomainName
\Administrator under the "Logon under This Account" in the 'Logon' tab
in services.msc. The server name inside the SQL server are set to
mixed mode.
Am I correct in thinking that changing the password field shown in the
"Login under This Account: DomainName\Administrator to match the new
domain administrator password will bring Joy?
Thanks!
Benoit
Sorry dude, I just saw this post. Yes, if you change a domain acct password,
you have to change it in the services config box as well.
However, let me caution you... running SQL under an admin acct is bad
enough, but running it under the domain admin acct is just irresponsible.
Seriously, create a separate acct for SQL and give it local admin rights if
you have to, but DON"T use the domain admin acct.
"bntgoogle@.yahoo.com" wrote:

> A reality check please...
> After changing the domain administrator password, we are no longer
> able to connect to databases on a MS SQL Server 2000 server when
> attempting to use ODBC drivers from W2K workstations.
> The MSSQLSERVER and SQLSERVERAGENT services both show DomainName
> \Administrator under the "Logon under This Account" in the 'Logon' tab
> in services.msc. The server name inside the SQL server are set to
> mixed mode.
> Am I correct in thinking that changing the password field shown in the
> "Login under This Account: DomainName\Administrator to match the new
> domain administrator password will bring Joy?
> Thanks!
> Benoit
>