Here is a quick snippet on enabling a SQL login to password expiration and password policies as per the Windows server: Open the SQL Server 2005 Management Studio. In the left pane, go to the desired server and navigate to the Security folder and expand it. Expand the Logins folder. Right-click on the desired login and click Properties . In the left pane of the Login Properties window, select General . Check if he Enforce password expiration checkbox is checked. Similarly to review the password policies...(
read more)
Read the complete post at http://sqlserver-qa.net/blogs/perftune/archive/2008/01/07/3118.aspx