1. Home
  2. Knowledge Base
  3. On-premise/Customer-Hosted Server
  4. SQL
  5. Changing Minimum Password and Username Length Requirements

Changing Minimum Password and Username Length Requirements

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'

Was this article helpful?

Related Articles

Need Support?

Can't find the answer you're looking for?
Contact Support