Q

Creating a login in SQL Server 2000 Enterprise Manager

Find how to create a SQL Server 2000 login account and then set user account rights to specific databases with "db_owner."

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

Dig deeper on SQL Server Security

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close