Problem

When attempting to initialize/create a database using DBConfig, you receive an error indicating that SQL Logins must have password policy enforced with CHECK_POLICY=ON.

 

Resolution

  1. Run dbcontrol -cleanup to remove anything leftover from the failed creation attempt.
  2. In step 6 of Initializing a new database, do the following:
    1. Click the Lock next to Internal Authentication Mode.
    2. Select Database Authentication in the dropdown.
    3. Create a password that meets your password policy requirements.
    4. Check the Enforce Password Policy box.

 

Cause

The domain or server has a password policy, and MSSQL has a trigger to enforce that newly created Logins must follow that password policy.