Post reply

SQL Password Expiration time

  • December 2, 2008 at 4:04 pm

    #128326

    Does anyone know what the default days until expiration is in sql 2005 for SQL passwords? Having a hard time finding an answer to this. I would assume it is 90 days but you know what happens when one assumes. Is it tied to group policy? Can it be changed?

    Thank you,

    Nick

  • December 2, 2008 at 4:21 pm

    #906565

    As per

    http://qa.sqlservercentral.com/articles/SQL+Server+2005+-+Security/sqlserver2005logins/2474/

    CHECK_EXPIRATION and CHECK_POLICY tell SQL Server to enforce the settings on password found in the computer's effective local security policy. Since Group Policy overrides the local security policy, the effective setting may actually be in a Group Policy. When CHECK_POLICY is on, SQL Server 2005 will get password policies and enforce them. However, CHECK_EXPIRATION can still be turned off, even if you want to ensure password complexity, password history, and account lockout settings are observed and enforced. If you set CHECK_POLICY on, though, CHECK_EXPIRATION will also be on unless you explicitly turn it off. CHECK_POLICY is only fully enforced in Windows Server 2003.

    MJ

Viewing 2 posts - 1 through 1 (of 1 total)

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