At a guess, I'd say the application is converting the password to upper case, which wouldn't have mattered on SQL Server 2000 (depending on the server collation) but definitely does matter on all later versions. Looks like you're going to need to choose a password with numeric, special and upper case only.
John