Password policy enforcement

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Password policy enforcement

Password policy enforcement

Rate Topic

Display Mode

Topic Options

Author

Message

MickyD

Posted Thursday, April 14, 2011 4:12 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 6:21 AM
Points: 166, Visits: 754

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

John Mitchell-245523

Posted Thursday, April 14, 2011 4:42 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 7:19 AM
Points: 4,434, Visits: 7,217

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 »

Permissions