Welcome to Lesson 7 of the SQL Server 2000 Tutorial. In this lesson we will cover adding logins. I hope you enjoy the lesson.

Adding Logins

Adding Logins
 

Part of a DBA's job is to create create new logins for SQL Server.  To create a new login, open up Enterprise Manager and navigate to logins (under the Security tree).  Right click and select New Login.

 

If you selected mixed mode authentication during SQL Server installation, you can create logins using Windows Authentication or SQL Server Authentication.  We will create login using SQL Server authentication.  We will use the login name: jsmith.  Type in a password and specify the default database as Northwind.
 

Click on the Database Access tab.  Although we specify that jsmith's default database is Northwind, we still need to grant him access to the database.  The Database Access tab is where we can grant him access to specific database(s).  Put a check in the permit box next to the Northwind database.

Then in the Database roles, select public, db_datareader, and db_datawriter.  This will allow jsmith to read (Select) data from tables as well as write data to tables.

Click OK.  SQL Server will prompt you to confirm the password of the login you just created. 

Click OK to create the login.  To test the new login, open up Query Analyzer and try to use the new login you just created.


If you create the login successfully, you should be logged in as jsmith and connected to the Northwind database.