Password policy enforcement

• MickyD

  SSCarpal Tunnel

  Points: 4601

  More actions

  April 14, 2011 at 4:12 am

  #389281

  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.

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  April 14, 2011 at 4:42 am

  #1311496

  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