Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Does the LoginProperty(LOCKOUTTIME) value reset when a locked account is unlocked? Expand / Collapse
Author
Message
Posted Tuesday, August 20, 2013 2:22 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 11:00 AM
Points: 979, Visits: 5,090
I found a script which generates a listing of SQL Logins and information culled from LoginProperty, including the LockoutTime value. What I'm curious to know is, does this value reset to 0 (well, OK, 1900-01-01 00:00:00.000) when a locked account is unlocked?

Now, we currently use the trick of:
alter login [{LoginName}] with check_policy = off;

alter login [{LoginName}] with check_policy = on;

to unlock an account, rather than fuss and fight with having to change the password, then change the password in any application which uses it...
Lazy, I know.

But my question still stands...

Thanks,
Jason
Post #1486431
Posted Tuesday, August 20, 2013 2:25 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 11:00 AM
Points: 979, Visits: 5,090
Never mind, I just spotted a couple accounts with values in there, which are not locked. So I'm inclined towards it does keep the last value.
Post #1486433
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse