Categories
SQL Server 2000

The service did not start due to a logon failure

When I go to SQL Server Enterprise Manager to create a New SQL Server Registration for localhost, I got an error message saying “The service did not start due to a logon failure“.

So, I copy this error message and google it. And quickly I found the solution. The problem is I have changed my network password and I didn’t update it at MSSQLSERVER. To do so, I went to Start > Settings > Control Panel > Administrative Tools > Services > MSSQLSERVER.

Then, I right click to go to Properties. At the Log on tab, I changed the password. Then, I went to SQL Server Service Manager to start it. I managed to start it. Then, I went back to SQL Server Enterprise Manager to create a New SQL Server Registration for localhost and it works!