An error message such as SQL error 1069: a service that did not start due to a logon failure is a common error that occurs when fail to start the service while restarting Microsoft SQL Server or SQL Server Agent.

Here at Bobcares, we have seen several such SQL related issues as part of our Server Management Services for web hosts and online service providers.

Today we’ll take a look at the cause for this error and see how to fix it.

Reasons to occur SQL error 1069

Often, Windows customers report that they are experiencing an SQL error while restarting Microsoft SQL Server or SQL Server Agent?

The error looks like,

Error 1069: The service did not start due to a logon failure.

This error happens when the service fails to start with the following error message:

Do you ever think why the SQL server service doesn’t start?

Here s the reasons,

1. This error arises due to the incorrect password of the SQL Server startup service account or the SQL Server Agent startup service account. Whenever change the password for the account, it is necessary to update for the SQL Server service or the SQL Server Agent service.
2. whenever the SQL Server is set to an account type other than the Local System account.

So, let’s see how our Support Engineers fix this error.

 

Remedies for SQL error 1069

Now, we can see how to fix this error.

In order to fix the error, our Support Engineers set up the Microsoft SQL Server service account with the right password on the SQL Server host computer.

For example, let’s see how to correct the password in Microsoft Windows 2000 Server and Microsoft Windows XP:

1. Initially, we click Start > Settings > click Control Panel> double-click Administrative Tools > double-click Services.

2. Then, for a default instance of SQL Server, we double-click MSSQLServer > go to Log On tab.
tab.
3. Next, we double-click SQLAgent, and then click the Log On tab.

4. Finally, we enter the correct password in the Password and Confirm password textbox, and then click OK.

At last, we start the SQL Server Service and the SQL Server Agent.

 

[Need any further assistance in fixing SQL errors? – We’re available 24*7]

 

Conclusion

In short, this SQL error 1069 arises when SQL Server service fails to start while restarting Microsoft SQL Server or SQL Server Agent. Today, we saw the reasons and how our Support Engineers fix this error.