Enforce Password Policy Configuration RRS feed

  • Question

  • As long as I read out the following article, If I checked ON of "Enforce password expiration" of SQL login account, it will follows to Local Security Policy setting on the server.

    SQL Server Login Properties to Enforce Password Policies and Expiration

    Is there any way to set up separately SQL account and OS account? I would like to set up maximum password age of SQL login account to 365 days, and local account for the server(=OS) to 60 days..  

    Tuesday, February 5, 2019 6:14 AM


  • No, it's not possible, the password police of SQL Server is bound to OS settings.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Marked as answer by KELLY_IRVINE Wednesday, February 6, 2019 12:20 AM
    Tuesday, February 5, 2019 9:38 AM