SQL Server problem

[Exceter]

I have a domain
SQL Server installed on the server
and I have the following problem:
:o Every time I change the domain admin password the SQL Server Service fails to start, and I need to reinstall the SQL Server.
how to solve this?

thanx.

[tridom]

I got this from the MSDN library. Let me know if you need more info on it.

When using Windows NT integrated security with SQL Server, the SQL Server login information must be identical to the Windows NT account information. Therefore, if you change the Windows NT password of the domain account that the SQL Server is logged on with, then you also must update the password in the following SQL Server services: MSSQLServer, SQLServerAgent, MSDTC, and the MODTBAD Office Developer DCOM component.

If you change a password, it must be updated on the server, the developer workstation, and the client computers. If the password is not updated for the SQL Server Agent, Access Workflow Designer cannot start and stop the agent automatically. Access Workflow Designer also uses the agent to manage time-out events for team solutions, so it is critical this service be set up properly.

[Exceter]

Thanx.
I got it.

[antares686]

If you SQL Server service setup to run under the Domain Admin as opposed to Local System account (which is the normal way) Then you need to open the services Control Panel and find the MS Sql Server then open the service properties and on the Logon tab set the correct password you just changed to.