When was Domain Account Password Changed in SQL Server? – Interview Question of the Week #093

If you are a DBA for quite some time, then at least once you must have encountered below error about Domain Account Password.

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

Question: When was Domain Account Password Changed in SQL Server?

Answer: I have already written a blog about this long ago.

SQL SERVER – Event ID 7000 – The service did not start due to a logon failure

In short, the problem occurs when the password for the SQL Server service account or the SQL Server Agent service account is not correct. As a part of account security, maintenance, domain administrators do change the password for the account. If it is changed in domain controller, but the password information was not updated for the SQL Server service or the SQL Server Agent service, then we will get this error.

I was trying to find a way to figure out the easiest way to know if the password was changed for the account without having domain administrator permissions. Here is the command which can do the magic. We can run below from the command prompt.

net user <AccountName> /domain

Here is the sample output

I have highlighted details which are needed for an investigation.

Reference: Pinal Dave (https://blog.sqlauthority.com)