Creating Users Without a Domain

To set up a SQL Server or Oracle database without a domain, you must first create a user account on both the client and server computers.

Note: This procedure only applies when using Windows NT authentication.
  1. Access the Windows Control Panel, and then choose Administrative Tools > Computer Management

    The Computer Management utility opens.

  2. In the left pane, click Local Users and Groups.
  3. Under Local Users and Groups, right-click the Users folder and choose New User. The New User dialog box opens.
  4. Type a valid user name in the User name text box, and the corresponding user’s full name in the Full Name text box.
  5. Type a valid password in both the Password and Confirm password text boxes, and then click Create.
  6. Repeat these steps on each client computer using the username and password.