Solved

The password for the user is too recent to change -- What is too recent

Posted on 2008-10-01
2
1,532 Views
Last Modified: 2009-04-15
I am using SQL Server 2005.

Some of my users have changed their password, and then tried to turn around and change it again fairly quickly.  Don't ask me why -- users will be users!

When they do, the error "The password for the user is too recent to change" is produced.

What is too recent??  Can I change the timeframe for this error?  Where?
0
Comment
Question by:wsturdev
2 Comments
 
LVL 19

Accepted Solution

by:
erikTsomik earned 500 total points
ID: 22616075
0
 
LVL 1

Author Comment

by:wsturdev
ID: 22616292
I read through the material you pointed me to, and it would appear that a way around this would be to turn Check_Policy off, then change the password, then turn Check_Policy back on, but this would unfortunately also allow bypassing of all password rules, which my company will not allow.

I don't know if I want to change the "too recent" parameter, yet.  But, I need to know how I find out what it is, so at a minimum, I can explain it to the user.  Depending on user pressure, if it is, say, 3 days, then I might want to change it to 1 hour or some shorter period.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Addition to SQL for dynamic fields 6 38
Help Required 2 32
sql server tables from access 18 18
SQL Syntax: How to force case sensitive query? 2 26
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question