SQL Server 2000 startup 1069 Error resolution

First, we introduce two common solutions on the network:

1. My Computer--control Panel--management tools--services--right key mssqlserver--properties--landing--Landing identity--Select "Local System Account"

Or:

2. My Computer--control Panel--management tools--services--right key mssqlserver--properties--landing--Landing identity--select "This Account"--Password and Confirm password to enter your modified administrator password.

The difference between the two:

Choose the first way, later modified the administrator password, no more adjustments (but require the system administrator to log on to the operating system)

Select the second way, later modified the administrator password, but also repeat the above operation.

Here's one of the things I've encountered:

This morning my colleague told me that his SQL could not log into his "Enterprise Manager". The reported error is "1069 error, because the login failed to start the service", the Internet to find the above two scenarios, but when I saw the window of the service and found a possible place to cause this problem, First we find the MSSQLServer service, then look at its properties, found that using a domain account to start the service to authenticate, and then asked whether to modify the login domain password, the answer is modified, because the domain has been set, a certain period after the user to change the password, and can not be the same as the previous password ( With the exception of the blank password, I have done the experiment ^_^). Then the password is reset here, then restart the service successfully, SQL can also log on successfully.

This problem found that when the password of the domain was modified, the login authentication information used by the corresponding service will not be updated automatically and need to be updated manually to resolve the problem. If everyone is more troublesome, it is simpler to modify the login status directly to the local system account as the above solution.