During a Microsoft SQL Server 2005 (standard or express) upgrade from a previous version or while updating SQL Server to a newer service pack (SP), you may receive the following error:
Error ID: 15116
SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Password validation failed. The password does not meet Windows policy requirements because it is too short.. To continue, correct the problem, and then run SQL Server Setup again.
Variations may appear depending on your configuration, including:
- The password does not meet Windows policy requirements because it is too long.
- The password does not meet Windows policy requirements because it is not complex enough.
- The password does not meet the requirements of the password filter DLL.
This will appear during the install process, but you may also have failed installs through Windows Update and not realize that this is the cause. The origin of the error is that your Domain or computer has a password policy set that a password that is hardcoded into a SQL script used during the upgrade fails to meet. Yes, it's an issue that Microsoft should have forseen. Yes, it's also an issue that Microsoft should have created a KB article for. Yes, The Grim Admin will fill in the holes...
The hardcoded password is "Yukon90_" and most often fails due to being too short. To complete the upgrade successfully, you have a couple options. The easiest solution is to temporarily change your password policy so that the hardcoded password meets the requirements and apply it to the server, then retry the installation. Alternatively, you can change the password in the upgrade script so it meets your current password requirements by performing the following steps.
- Run the SQL Server installer, accept the licensing terms, install/verify prerequisites, and let it scan your configuration so that you eventually end up at the "Welcome to the Microsoft SQL Server Installation Wizard" screen.
- At this point, navigate to the folder where SQL is currently installed and open .\Upgrade\sqlagent90_msdb_upgrade.sql in a text editor.
- e.g., C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Upgrade\sqlagent90_msdb_upgrade.sql
- Find the line
encryption by password = 'Yukon90_'and change the password so it meets your requirements. This password may appear a couple times in the script so search for it more than once.
- Side note: If you run into this error during an install rather than an upgrade, you can do a similar edit to the .\Install\instmsdb.sql script (the offending password appears twice in this script).
- After saving the upgrade script, continue on with the install, which should now finish without the permission error.