SQL Server 2005 Password Expiration

[funcrecall12]

hello Guys,

I am planning to enable the Password policy - for sql server 2005 - to have the sql account to expire within 60 days.

Now this box is was not new - old one built around May2008 and also those sql account. I plan to enable the password expiry on this coming last week of July 2009.

But I do not plan to enable the "User must change password next login" only this two "Enforce Password Policy" and "Enforce Password Expiration" will be enable.

Will the sql account be expired the moment I tick this 2 policy - ?

Thank you.

Jebs!

 

[mrdenny]

I would plan on it expiring at that time.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog