Windows IT Pro is the leading independent community for IT professionals deploying Microsoft Windows server and client applications and technologies.
  
  
  Advanced Search 


Return to article

How can I resolve the error 'An error 1069 - (The service did not start due to a logon failure)' for SQL Server?
 

A. SQL Server is just like any other NT service in that it can be defined to run using the credentials of an NT user account. It can also run under localsystem account, but if you are getting this error then you must have defined a user account.

Go to control panel/services. Choose the mssqlserver service (or SQLExecutive/SQLAgent if they are failing) and then choose startup. Check what NT account is being used. Make sure that the password is correct and check with NT user manager that the account has not been deleted or expired.

If the account details seem ok, then check that it has "logon as a service" user right (again with user manager).

If this doesn't resolve the issue then try logging on locally to the NT box with the same NT account and see what error(s) you get.








Reader Comments

Thank you! It solved my problem. Thanks again!

erik -July 03, 2001

Your Comments (required):Solved my problem as well.

Name (required):Eric -June 24, 2004

Thanks, worked for me!

Anonymous User -May 02, 2005

Este articulo resolviò mi problema! Gracias!!!

Anonymous User -May 20, 2005

Hey buddy this works well for me thanx!

vinayaksm -June 30, 2005

it worked thanx

Anonymous User -July 03, 2005

fantastic, if i meet you in a pub, I'll buy you a beer mate!

Anonymous User -August 05, 2005

THANKS

Anonymous User -August 16, 2005

Very useful. You have solved my problem

josepbocanegra -May 24, 2006
Windows IT Pro Home Register FAQ for Windows WinInfo News
Europe Edition About Us Contact Us/Customer Service Media Kit Affiliates / Licensing  
SQL Server Magazine Office & SharePoint Pro DevProConnections IT Job Hound
Left-Brain.com Technology Resource Directory asp.netPRO ITTV Windows SuperSite 
 
 Windows IT Pro is a Division of Penton Media Inc.
 © 2009 Penton Media, Inc. Terms of Use | Privacy Statement