administrator password and sql startup

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: bntgoogle@xxxxxxxxx
Date: Thu, 08 Nov 2007 15:26:27 -0800

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

.

Prev by Date: Re: SQL SERVER coonecion nError 2 and 17 during Access to SQL upsizing
Next by Date: Re: SQL Server Management Studio don't see local SQL Server 2005 D
Previous by thread: SQL SERVER coonecion nError 2 and 17 during Access to SQL upsizing
Next by thread: how to return a value in a stored procedure?
Index(es):
- Date
- Thread

Relevant Pages

RE: SQL Server Agent Logon Issue (SBS 2003)
... The service did not start due to a logon failure. ... the SQL Server startup service account or the SQL Server Agent startup ... service account is not correct. ... Microsoft CSS Online Newsgroup Support ...
(microsoft.public.windows.server.sbs)
Re: Windows Auth to SQL Server from ATL Web Service not working...
... account I'm logged on as. ... SQL on a different box from my web service in an Atl Server web ... impersonation token is not passed on to the SQL Server. ... Event Category: Account Logon ...
(microsoft.public.vc.atl)
Re: Problems changing the password for the service account in SQL
... Adding the domain account which runs SQL Server into SQL Server doesn't ... Server if it is running under the domain account. ... Admin-SQL, Logon Exec - exception from ...
(microsoft.public.sqlserver.security)
SQL services failing on startup
... The services are set to autostart using a windows account. ... The account is restricted to logon only to computers ... for several months, the last two weekends, SQL Server has failed to startup ... The domain account was a member of the local admin group. ...
(microsoft.public.sqlserver.server)
Re: Services Not Retaining Logon Info
... What account are you using to start these services up at logon? ... logon information. ... SQL Server ...
(microsoft.public.windows.server.general)