How do I create a user account in SQL Server 2000?

Question

My project needs a SQL Server 2000 User Id and password created for an ASP.NET website. How do I create a user account in SQL Server 2000?

Answer 1

I've always used the SQL-Enterprise manager to create the user accounts and set the permissions for the databases and the access. See this intro tutorial.

Answer 2

Basically, you'll have to run the system stored proc sp_addlogin.

See Example "A" in the link.