Using the Create Login Wizard

[sukishan]

Using the Create Login Wizard
  New Information - SQL Server 2000 SP3.

Although the steps required to grant login access to Microsoft® SQL Server™ and a database can be performed separately, the Create Login Wizard can simplify the process. The Create Login Wizard allows you to:

Choose which authentication mode to use to connect to an instance of SQL Server (Windows Authentication Mode or Mixed Mode).

Add a Microsoft Windows NT® 4.0, Windows® 2000 or SQL Server login.

Security Note  When possible, use Windows Authentication.

Add a Windows NT 4.0, Windows 2000 or SQL Server login to a fixed server role.

Add a Windows NT 4.0, Windows 2000 or SQL Server user to one or more databases, thereby granting the user access to those databases.