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

Neil Pike

December 23, 1999

1 Min Read
ITPro Today logo

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.

Related: Automate detection of Logon failure in a domain environment 

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: Logon failures on BDC due to secure channel problem

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like