HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Login lifespan for password on SQL Server

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
sqlloginpasswordforlifespanserver

Problem

What is the "lifespan" for a login with the option Enforce Password Expiration Enabled?

Where can I find configuration/option to change the time?

Solution

Per the following article, This information can be found in:

Start -> All Programs -> Local Security Policy

Then navigate to Account Policies -> Password policy

You should see something similar to this:

http://www.mssqltips.com/sqlservertip/1088/sql-server-login-properties-to-enforce-password-policies-and-expiration/

Context

StackExchange Database Administrators Q#86903, answer score: 6

Revisions (0)

No revisions yet.