Re: password expiration
- From: K. Brian Kelley <brian_kelley@xxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 23 Mar 2007 00:34:40 +0000 (UTC)
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/
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
How do we enable password expiration on sql 2005. Just upgraded.
.
- References:
- Re: password expiration
- From: Sue Hoegemeier
- Re: password expiration
- Prev by Date: Re: Default name for domain
- Next by Date: Error when Logging on - Error: 18456, Severity: 14, State: 16
- Previous by thread: Re: password expiration
- Next by thread: I need to restrict [database].MDF file's using on other MSSQL server. HELP!!!
- Index(es):
Relevant Pages
|
