Modify the Windows account password to cause SQL Server 2000 to fail to start

Modifying the Windows account password causes SQL Server 2000 to fail to start. --The symptom is a SQL Server 2000 database that is logged on to Windows XP as an administrator or equivalent user. After you modify this Windows account password, SQL Server 2000 cannot start, and the error message is: "A connection to the database could not be established." Cause: SQL Server does not exist or access is denied. " "Error 1069 occurred and the service could not be started because of a logon failure. "--reason because the account that was changed password is the same account as the database that is established. By default, the account that establishes the database is used as the starting database service. After you modify the password in Windows, the user name/password that SQL Server 2000 uses to start the service is not modified consistently. When you start the SQL Server service again, the user name/password that was modified is used, and it is inconsistent with the current correct user name/password.

1. Change the Windows account password back to the original database; 2. Open SQL Server Enterprise Manager, start the database, expand SQL Server group \ Right-click the database server you want to change \ Select Properties; 3, go to security tab, select the System account in the start service account. 4. When you restart the database in SQL Server Enterprise Manager, you should be able to start the database successfully. 5. Now try changing the Windows user password again, and you should be able to see that SQL Server is no longer affected.

Modify the Windows account password to cause SQL Server 2000 to fail to start