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. To make changes to the account you’ll have to change the username to be 8 characters or longer. We recommend just using their email, and there is even a setting to force users to use their email as their username.

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 get the error or message that your users 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’

(Can have the number with either no quotes or single quotes typed in)

 

If you’re still having any issues, or using Windows Authentation 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