SQL Server 2014 with PowerShell v5 Cookbook

Creating domain accounts

In this section, we will create some domain accounts that we will use for our exercises. We will create the following domain accounts:

• QUERYWORKS\sqlservice
• QUERYWORKS\sqlagent
• QUERYWORKS\tstark
• QUERYWORKS\srogers
• QUERYWORKS\todinson

To add these accounts, perform the following steps:

1. Launch SQL2014VM and log in.
2. In Server Manager, click on the Tools menu item and select Active Directory Users and Computers.
3. In the Active Directory Users and Computers window, expand queryworks.local. Right-click on Users and navigate to New | User.
4. In Full Name and User logon name, type sqlservice and click on Next, as shown in the following screenshot:
5. Type the password and then check User cannot change password and password never expires, as shown ...