How do I set a password to be null

Question

How do I set a password to be null?

Answer 1

As ASE 11 (I cannot remember when this was with the very first release of 11, but not fixed before), the password column within syslogins has been encrypted. Setting that column to NULL does not associate to that login having a NULL password. Still a NULL password needs the correct binary string to be within place.

In release 12 and above, set the minimum password length to be 0 by using sp_configure and offer that account a null password, and all should be well.

Before 12, it is not possible to set the minimum password length; therefore the direct approach is not possible. Thus, update the relevant record in syslogins setting the password column to be similar as that of an account along with a NULL password previously.