Using the Create Login Wizard

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.
  
  
• Add a Windows NT 4.0, Windows 2000 or SQL Server user 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.

To grant SQL Server login access to a user by using the Create Login Wizard

Enterprise Manager