MSSQL SERVER CHECK_POLICY = ON / OFF

While creating a user on the sql server, the chech policy parameter tests the conformity of the user password and the db password structure.

CREATE LOGIN EKARA WITH PASSWORD = ‘a’, CHECK_EXPIRATION = OFF, CHECK_POLICY = off, DEFAULT_DATABASE = xyz;
I get the error you would expect:

CREATE LOGIN EKARA WITH PASSWORD = ‘Abcd_2021?’, CHECK_EXPIRATION = OFF, CHECK_POLICY = on, DEFAULT_DATABASE = xyz;

Commands completed successfully.