With MSDE 2000 the default security is Windows Authentication.  If you change the following registry settings this will allow you to use SQL logins.

Change the loginmode file from 1 to 2

HKEY_LOCAL_MACHINE/ SOFTWARE / MICROSOFT/MSSQLSERVER/MSSQLSERVER/loginmode

cheers