Recently EIOBoard has had a security update that increased the default minimum length of usernames and passwords to 8. They may result in you being unable to edit users due to the error “user name must contain 8 characters” coming up when making any edit to the user page.
You can change the username and password requirements in the Web Admin at the bottom of the ‘Global Settings’ page.
If you’re on Cloud, the minimum length allowed is 8 since the usernames must be globally unique, not just unique to your organization. We recommend using users’ emails, and there is even a setting to force users to use their email as their username. Users whose usernames were set before 10.3 are grandfathered in, but to make changes to the account, you’ll have to change the username to 8 characters or longer.
On-Premise Hosting
If you have an on-premise installation, you can also manually set these settings to be less through the SQL database. You can do so by running these two scripts against the SolutionSavant Database on the server.
If you’ve updated the requirements and are still getting the error or message that your user’s passwords do not meet minimum requirements, you can reset the “Password Meets Minimum Requirements” flag for all users in the database as well:
UPDATE OrganizationSettings SET PasswordMinimumNumberOfCharacters = 3 UPDATE OrganizationSettings SET UserNameMinimumNumberOfCharacters = 3 UPDATE dbo.Users SET PasswordMeetsMinReq = 'true' WHERE PasswordMeetsMinReq = 'false' (You can have the number with either no quotes or single quotes typed in)
If you’re still having any issues or using Windows Authentication and don’t need the passwords at all, you can run this script to fully remove any password requirements:
UPDATE OrganizationSettings SET PasswordMinimumNumberOfCharacters = 1 UPDATE OrganizationSettings SET UserNameMinimumNumberOfCharacters = 1 UPDATE OrganizationSettings SET PasswordMinimumNumberOfSpecialCharacters = 0 UPDATE OrganizationSettings SET PasswordMinimumNumberOfLowerCaseCharacters = 0 UPDATE OrganizationSettings SET PasswordMinimumNumberOfUpperCaseCharacters = 0 UPDATE OrganizationSettings SET PasswordMinimumNumberOfNumerics = 0 UPDATE dbo.Users SET PasswordMeetsMinReq = 'true' WHERE PasswordMeetsMinReq = 'false'