Yukon: Password Validation Failed

From: Kostil (anonymous_at_discussions.microsoft.com)
Date: 02/24/04 

Date: Tue, 24 Feb 2004 12:36:06 -0800

On sqlservercentral.com we have been discussing a problem that hit one of the forum readers. In SQL Server Yukon Beta, he was unable to create SQL Server login, the error message read: Password Validation Failed, Does not meet Complexity requirments. I was testing this problem on my own server, and it turns out that if setting "Password Must Meet Complexity Requirments" in Local Security Policy is enabled, than SQL Server will not allow weak password (username: admin, password: admin). Although, it is a bad idea to give this sort of password to user.
Now, if the computer running Yukon was a part of the domain, but then was disconnected, and Local Security Policy about complex passwords is disable, why does SQL Server still does not allow to assign password the same as username? I repeat, that I tested this problem on stand alone computer and eveything worked with Local Security password complexity disabled. Why, this person is experiencing this problem and I don't?

Thank you,
Kostil