SQL Server logins - enforce Password Expiration and policies

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 on the server then you should have relevant ADMINISTRATOR privileges on the server. Once you have obtained them do the following

• Click the Start button.
• Select All Programs.
• Select Administrative Tools.
• Select Local Security Policy.
• The Local Security Settings window will appear.
• In the left pane, expand Account Policies.
• Select Password Policy.
• In the right pane, check the security settings

Though this is fully documented in the SQL Server Books Online, but not many new users would know about it and by default a search on the web is retained. Whereas if your logins are authenticate via WINDOWS authentication then you need to perform the 1st set of steps above, only refer to the security policy on the number of days the password policy will have updated.