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...