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!
Tags: New SQL Server Registration localhost, SQL Server Enterprise Manager, The service did not start due to a logon failure
15 August 2008 at 1:15 pm |
Hi,
Thanks for your help. Yes it works for SQL SERVER as well as for SQL AGENT SERVICES.
ones again thanks
20 April 2009 at 10:44 am |
Hi,
Thanks for your help. It was easy to find and worked perfectly.
Sincerely,
Robert
15 May 2009 at 6:17 am |
Thanks for your help, I did it early and started my SQL Server Enterprise Manager.
Thank you once again for such greate and quick response.
Your’s Truly
Irshad Bacha
8 June 2009 at 3:50 am |
You save my life. Many Thanks