password expiration

How do we enable password expiration on sql 2005. Just upgraded.It's enabled on the server by default - but only supported
on Windows 2003.
You set the expiration on a per login basis - it's not
server-wide setting. So you set it for any SQL Login.
For password expiration, you also need to turn on
CHECK_POLICY (or the Enforce Password Policy option if using
the GUI.
You can find more information in the help topic on Password
Policy:
http://msdn2.microsoft.com/en-us/library/ms161959.aspx
-Sue
On Wed, 21 Mar 2007 10:19:03 -0700, deseotu5
<deseotu5@.discussions.microsoft.com> wrote:

>How do we enable password expiration on sql 2005. Just upgraded.|||Also, it will take the settings of the server if it is enabled. In other
words, in the case where there's not a domain policy, it'll use the password
policies set for the local security policy of the server. Otherwise it'll
use the domain policy.
K. Brian Kelley, brian underscore kelley at sqlpass dot org
http://www.truthsolutions.com/
[vbcol=seagreen]
> It's enabled on the server by default - but only supported
> on Windows 2003.
> You set the expiration on a per login basis - it's not
> server-wide setting. So you set it for any SQL Login.
> For password expiration, you also need to turn on
> CHECK_POLICY (or the Enforce Password Policy option if using
> the GUI.
> You can find more information in the help topic on Password
> Policy:
> http://msdn2.microsoft.com/en-us/library/ms161959.aspx
> -Sue
> On Wed, 21 Mar 2007 10:19:03 -0700, deseotu5
> <deseotu5@.discussions.microsoft.com> wrote: