Setting Up SQL Server Without a Domain

To set up SQL server without a domain:

  1. Access the Windows Control Panel, and then choose Administrative Tools > Computer Management

    The Computer Management utility opens.

  2. In the left pane, expand Local Users and Groups, and then click Groups.
  3. In the right pane, double-click Users.

    The Users Properties dialog box opens.

  4. Click Add.

    The Select Users, Computers, or Groups dialog box opens.

  5. Click Advanced, then use the Common Queries tab to search for users.
  6. Click Find Now, and then select users from the list. Alternatively, click in the Enter the object names to select text box and enter the [user ID] of the user you want to give access.[user ID],:
  7. Click OK to save the user information and return to the Users Properties dialog box.
  8. Repeat the previous steps to create additional user accounts.
  9. Click OK.