Because SQL Server uses Windows NT user authentication, your SQL Server users must have valid Windows NT accounts. Before creating SQL Server logins, use the following steps to create Windows NT user accounts.

In addition, before you can add users to Windows NT groups, each user must have a valid Windows NT domain account.

To create a new user account

1. From the Start menu, select Programs, then Administrative Tools (Common), and then User Manager for Domains.
   
   
2. From the User menu, select New User.
   
   
3. Type appropriate information in the dialog box:
   • In Username, type a user name.
     
     
   • In Full Name, type the user's complete name.
     
     
   • In Description, type a description of the user or the user account.
     
     
   • In both Password and Confirm Password, type a password of up to 14 characters.
     
     
   • Click to select or clear the check boxes for User Must Change Password at Next Logon, User Cannot Change Password, Password Never Expires, and Account Disabled.
4. To administer a Group, Profile, or Dialin associated with the New User box, click the button, and complete the dialog box that appears. Then click OK.
   
   
5. Click Add.

To add another user account, repeat steps 2 through 5.

Note   The buttons available in the New User dialog box depend on whether you are administering domains or workstations.

• The Groups, Profile, and Dialin buttons always appear.
  
  
• The Hours, Logon From, and Account buttons appear only when you administer domains.