Mssql05 "password validity Verification Failed. The password is not complex enough and does not comply with Windows policy requirements ."

Make a good table creation script and test it in the company,

Let the on-site execution report

"Password validity Verification Failed. The password is not complex enough and does not comply with Windows policy requirements ."

 

Create login [mcu32] with Password = n' mcu32', default_database = [cscstd20], check_expiration = OFF, check_policy = on

You can change the last sentence from on to off ....

Create login [mcu32] with Password = n' mcu32', default_database = [cscstd20], check_expiration = OFF, check_policy = off

Otherwise, I will change the password ~! @ # Mcu32 @ HB

This complexity is useless...

It seems that this wndow strategy is a bit cool...