Share via


Creating a New Windows 2000 User Account

Because Microsoft® SQL Server™ uses Microsoft® Windows® 2000 user authentication, your SQL Server users must have valid Windows accounts. Before creating SQL Server logins, use the following steps to create Windows user accounts. In addition, before you can add users to Windows groups, each user must have a valid Windows domain account.

To create a new user account

  1. From the Start menu, point to Programs, then Administrative Tools, and then click Computer Management.
  2. Expand Local Users and Groups, select Users, and choose New User from the Action menu.
  3. In the New User dialog box, enter the appropriate information:
    • In Username, enter the user's alias. Typically, this is based on the user's full name.
    • In Full Name, enter the user's complete name.
    • In Description, enter a description of the user or the user account.
    • In both Password and Confirm Password, enter a password of up to 14 characters.
    • Specify additional options: 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. Click Create.

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

See Also

Creating User and Group Accounts | Creating a New Local Group Account | Creating a New Global Group Account