how to create a database user in SQL 2000?

[longmatch]

I am trying to create a new user for my SQL 2000 server. Unfortunately I am not be able to do it. This is what I did:
1.click SQL server - enterprise manager - database - residency(database name)- right click Users to click - new database user, then "Database user propertes - new user window" popup.
2. click 'login name' dropdown to select 'new', "SQL Server login properties - new login" comes out.
3.in 'name' textbox I type in 'firstnewuser' as login name, then check the 'SQL server authentication' radio button, 'password' field comes out. I type in 'test' as password, select 'residency' database in 'database' dropdown list, keep 'default' in 'language' dropdown.then click ok.
4. A 'confirm password' window came out for some reason. it asks me to put 'old password' and 'confirm new password'. You know it is a new login account in this database, I do not have old password. I would like to know how to deal with the 'confirm password' window.

Our DBA give me administrator right in my Windows Authentication.

thanks

longmatch

 

[ClaireHCM]

In the confirm password ,type "test".Since you assign the pwd as test in the {3rd step}!

 

[longmatch]

When I put test both in 'old password' and 'confirm new password' box, a error message came out. it says 'Error 22020:[sql-dmo] you must be logging in as 'sa' or a member of sysadmin, or a member of securityadmin to perform this operation.'. It looks like I do not have enough right to do this, right?. But our DBA just show me he gave me the admin right in this database in Window authentication'. Not sure what is wrong.

Thank you for your help

Longmatch

 

[ClaireHCM]

In this database?no...since you are creating a new login in the server, not only creating new user to this database.
You can ask your DBA to enable you as a security administration and enable you as db_accessadmin permission.

Or,ask your dba to create the login that you are going to add to that database.So you can select from the scrolled list.

I dont recommand that DBA assign any administration permission to any user other than dba.

 

[ClaireHCM]

But if it's development box ,then it's fine.

 

[longmatch]

Actually I just want to create a new user for my special database, not a sql server login. What is the difference between database user and database login. To my knowledge, I need to click security-new login to set up a SQL server user account. Does the database user have to be a sql Server user first?

Longmatch

 

[ClaireHCM]

Yes...before adding into a database as a USER.You need to have a LOGIN in the sql server.

In this case if you dont want to create any new server login.Just pick one login from the scrolled list and add it as a user into the database,dont go thru &quot;<new>&quot; again