Alter Login

• Raghavender Chavva

  SSCrazy Eights

  Points: 8669

  More actions

  December 20, 2010 at 3:06 pm

  #146726

  Hi All,

  We have some logins need to be remove password expiration option from them.

  When I tried to change it, it saying cannot change when the MustChange option is on.

  Error:

  The CHECK_POLICY and CHECK_EXPIRATION options cannot be turned OFF when MUST_CHANGE is ON.

  So we tried to change that option using alter login and unlock, here we dont want our password to be changed, and we dont know the password of those logins, so I have used hashed password and tried to change it:

  Query:

  ALTER LOGIN [Test11] with PASSWORD =0x01001783b0e1d2997bd4a613c96165ec9381fb2e5b76b8cdd92b hashed unlock

  Error:

  A HASHED password cannot be set for a login that has CHECK_POLICY turned on.

  How to handle this situation ?

  Thank You.

  Regards,
  Raghavender Chavva

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  December 20, 2010 at 9:21 pm

  #1264875

  Hi Raghavender,

  You can workaround this situation by altering the login as in the below script. More details here[/url]

  ALTER LOGIN [LoginName]

  WITH

  CHECK_POLICY = OFF,

  CHECK_EXPIRATION = OFF

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga