Subscribe to Windows IT Pro
December 24, 1999 12:00 AM

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

Windows IT Pro
InstantDoc ID #14376
Rating: (13)

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.


Related Content:

ARTICLE TOOLS

Comments
  • josepbocanegra
    6 years ago
    May 24, 2006

    Very useful. You have solved my problem

  • Anonymous User
    7 years ago
    Aug 16, 2005

    THANKS

  • Anonymous User
    7 years ago
    Aug 05, 2005

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

  • Anonymous User
    7 years ago
    Jul 03, 2005

    it worked thanx

  • Vinayak
    7 years ago
    Jun 30, 2005

    Hey buddy this works well for me thanx!

You must log on before posting a comment.

Are you a new visitor? Register Here

advertisement

advertisement

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.