Purpose

The purpose of this article is to teach you the process of granting a SQL Server login access to a database in Microsoft SQL Server 2000.

To Grant a SQL Server Login Access to a Database

The objective of this article is to teach you the process of granting access to a database in Microsoft SQL Server 2000. Add a Microsoft SQL Server user account to each database for each SQL Server login that requires access to the database. If a user is not created in the database, the SQL Server login cannot access the database.

To grant a SQL Server login access to a database, the SQL Server login must already exist. Furthermore, SQL Server logins must be granted access to a database one at a time.

Following steps describe you the step by step details of granting a SQL Server login access to a database:

1. Click Start, go to Programs, then go to Microsoft SQL Server, and click Enterprise Manager.

2. Expand Databases, then expand the database i.e. MyDatbase for the user to which the access is to be granted.

3. Now, right click the Users, and click New Database User...

4. Select the login name from the Login Name drop down menu, and also give a user name in User Name field, and select the roles for this user.

5. Now, click OK.