Post reply

How do i Set Password Expiration days for a SQL Login

  • December 21, 2007 at 12:09 am

    #185176

    Hi,

    I am creating a Login in code while Installation. I have a requirement now that Login should have Password expiration policy. How do i set this? Please help.

    Thanks

    Chelladurai

  • December 21, 2007 at 4:45 am

    #762043

    Hi

    If you are creating logins from SSMS you check the checkbox which says "Enforce password policy".

    If you are using a script use the CHECK_EXPIRATION option of the "Create login" statement.

    "Keep Trying"

  • December 23, 2007 at 10:40 pm

    #762482

    Hi,

    Thanks for your response. How can i set the Interval for Password Expiration.

  • December 23, 2007 at 11:05 pm

    #762487

    Hi

    check this out

    http://www.mssqltips.com/tip.asp?tip=1088

    "Keep Trying"

  • December 23, 2007 at 11:38 pm

    #762493

    Hi,

    Thanks a lot!

  • December 24, 2007 at 1:30 am

    #762507

    As far as I know, if the SQL Server is on a domain, the domain's password policy is the one that's enforced. If the server's not on a domain, then the local password policy is enforced.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 5, 2010 at 8:18 am

    #1231728

    Hi! I just read this thread (3 years later). Does anybody know how I can get a notification that someone's password will expire in another n days? or to trigger an SP to take action n days before expiry? I'm assuming an SQL server login with Enforce Password Policy and Enforce Password Expiration. Thanks in advance ...

  • October 5, 2010 at 8:32 am

    #1231746

    Use the LOGINPROPERTY method to find all the infos you need (http://msdn.microsoft.com/en-us/library/ms345412.aspx).

  • April 12, 2016 at 8:34 am

    #1871418

    Thank you, the link worked for me.

    Jeff

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply