Query to check when the SQL Server Service account password was last changed.

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  June 16, 2014 at 1:13 am

  #396915

  Hello,

  Is there any query available to check when the SQL Server service account password changed last time?

  Regards.

  Thanks.

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  June 16, 2014 at 2:50 am

  #1721856

  Probably not - it's not something that SQL Server controls. You'd be better off speaking to your AD administrator.

  John

• ScottPletcher

  SSC Guru

  Points: 100948

  More actions

  June 16, 2014 at 1:13 pm

  #1722087

  If you are using a native SQL account, you can check in:

  sys.server_principals

  There is no date specifically for password changes, but the modify_date does get reset when the password is changed.

  SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.