Problem:
SQL Server 2005 was updated from RTM to SP3. Now when attempting to publish a site in ICTool the following message is displayed: Password Validation failed. This password does not meet Windows policy requirements because it is not complex enough.
Solution:
SQL Server updates change-the-password requirements for complexity. Options:
- Disable enforcement of this password policy on Spitfire and SpitfireRO logins from SQL Server Management Studio.
- Enter complex passwords for the Spitfire and SpitfireRO logins in ICTool that meet the requirements.
Additional Comments:
1. If you have multiple Spitfire sites, be sure to change the passwords for the Spitfire and SpitfireRO in each of the ICTool configurations you have. Since the logins appear once in SQL Server, each usage of these logins must have the same password.
2. If the default password complexity policy is enabled, passwords must meet the following minimum requirements:
- Not contain all or part of the user‘s account name
- Be at least six characters in length
- Contain characters from three of the following four categories:
- English uppercase characters (A through Z)
- English lowercase characters (a through z)
- Base 10 digits (0 through 9)
- Nonalphanumeric characters (e.g., !, $, #, %)
Complexity requirements are enforced when passwords are changed or created.
KBA-01436; Last updated: September 18, 2017 at 10:27 am;
Keywords: password, policy, ictool, SQL, complex passwords,