Ask the Expert

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?

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: