Yes. SQL Server 2005 installed on Windows 2003 enforces the local password
policy for all SQL Server logins. SQL Server 2000 does not have this
capability, so they behave differently.
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.