patternsqlMinor
Login lifespan for password on SQL Server
Viewed 0 times
sqlloginpasswordforlifespanserver
Problem
What is the "lifespan" for a login with the option
Where can I find configuration/option to change the time?
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/
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.