Creating a login in SQL Server 2000 Enterprise Manager
How can I set up a user login and password through Enterprise Manager in SQL Server 2000?
In SQL Server 2000, there are two concepts: a "login" which allows connection to the SQL Server itself, and a "user" which allows connection to a particular database. They may seem to be redundant, but they serve two different purposes. In most cases, there is a 1:1 relationship between a login and a user, just to keep things simple. To create a login, expand out the "Security" folder underneath your SQL Server object in the left window pane. Beneath this folder, you will find an object called "Logins." Right-click "Logins" and select "New Login." Enter the name of the new login and select either Windows-based (more secure) or SQL-based (more compatible) authentication. Enter a password and select a default database for this new login.
Now flip over to the "Database Access" tab. Place a checkbox next to the database that this login should have access. Further down below, under database roles, you will probably want to enable the "db_owner" role, so that this login has full access to the database. When you're done developing or troubleshooting, you'll want to revisit this role and perhaps grant it less rights for increased security.
This was first published in December 2007