Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

Enabling "Enforce password expiration" on an account with an old password Expand / Collapse
Posted Wednesday, November 6, 2013 8:19 AM



Group: General Forum Members
Last Login: Thursday, December 1, 2016 2:17 PM
Points: 1,772, Visits: 10,711

That's what I was afraid would happen. I'll have to talk this over with my boss, see how he wants to tackle it. It was like this when I started, despite the requirement, so maybe someone either was gaming the system (auditor is coming! Enable it!) or they got a "pass" on having it enabled.
Post #1511902
Posted Friday, August 8, 2014 7:16 AM

Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Tuesday, November 29, 2016 5:42 AM
Points: 669, Visits: 592
Well you can alter all the current users by running below code...

USE master

SELECT 'ALTER LOGIN ' + '[' + name + ']'+ ' WITH
CHECK_EXPIRATION = ON; 'FROM sys.sql_logins
WHERE is_policy_checked = 0
or is_expiration_checked = 0

Execute your results and you should be fine!
Post #1601160
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse