newbie question: How to add extra SQL Auth. account?

[geohohk]

hi all,

I'm new to DB. I know we have a built-in account of SA. But I want to build an extra account using SQL auth instead of Windows-autho.

I can't find the interface to create an account.
Is there an interface? What would be the script to create such account?

thx
George

[Delerna]

You create new accounts in the security/logins branch of the server tree in enterprise manager.
Once an account is set up there then you add it to the users branch for each database that you want the user to have access to.
Once you have added the user to the database then you have to set the access privilages for each table/view/stored proc etc in the database that you want them to have access to.

[geohohk]

It works.
THx a lot.