Error 27506 - Password validation failed

Owned by Chris Hayes
Last updated: Apr 08, 2024

 

You will receive this error if your organisations Group Policy is set to only allow passwords that are longer than 11 characters. The SQL password our software is trying to set at this stage of the install for the user ‘mapp’ is only 11 characters in length. We are working on a fix for this but the workaround is below. Please use Solution 1 if you do not have/are unable to install SQL Server Management Studio

Solution 1

  1. Locate your security Group Policy Object (GPO) and change the minimum password length to 11 characters

  1. On the server you are installing our software on, open a cmd prompt as administrator and run

    gpupdate /force

  2. Try installing our software tool again

  3. Change your GPO back to how it was previously

  4. Run gpupdate /force again to restore your correct password policy on the server

Solution 2

  1. Open SSMS (SQL Server Management Studio) on the machine where the SQL instance our software is going to use is located

  2. Connect to the SQL instance using the SA account

  3. Expand Security > Right click Logins > New Login…

  4. Create a SQL Server authentication account called mapp with a password of foobaR#1Abc > remove the ‘Enforce password policy’ check

  5. Under Server Roles tick sysadmin > click OK

  6. Try installing our software tool again