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

Password policy enforcement Expand / Collapse
Author
Message
Posted Thursday, April 14, 2011 4:12 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 2:22 AM
Points: 229, Visits: 1,155
Hi
Hope someone can help me out here.
I need to ensure that password policies are not enforced when a new SQL login is created.

what do I need to do to ensure that policies are not enforced when account is created ?
Currently all new logins have the enforce password policy box ticked.

In addition is there anyway to turn off password policy on accounts already created ?
Have over a 1000 accounts that need changing...

Cheers for any advice.
Post #1093399
Posted Thursday, April 14, 2011 4:42 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:43 AM
Points: 5,383, Visits: 9,954
For the first problem, a DDL trigger should be what you need.

For the second problem, look up the syntax for ALTER LOGIN. You'll also need to use that in your DDL trigger.

John
Post #1093404
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse