Creating domain accounts

Next, we will create some domain accounts to be used for our exercises. We will create the following:

• QUERYWORKS\sqlservice

• QUERYWORKS\sqlagent

• QUERYWORKS\aterra

• QUERYWORKS\jraynor

• QUERYWORKS\mhorner

To add these accounts, follow the steps listed below:

1. Launch SQL2012VM and log in.

2. Go to Start | Administrative Tools | Active Directory Users and Computers.

   

3. In the Active Directory Users and Computers window, expand queryworks.local. Right-click on Users and select New | User, as shown in the following screenshot:

   

4. In Full name and User logon name, type sqlservice and click on Next as shown in the following screenshot:

   

5. Type the password, then check User cannot change password and Password never expires, as shown in the following screenshot:

   

6. Click on Next and then Finish.

7. Repeat steps 3 to 6 for creating the rest of the users:

   • sqlagent

   • aterra

   • jraynor

   • mhorner