Server building domain control with AlwaysOn environment process for SQL Server (i) setting up a domain control server

0 Preparation Phase

1. Windows Server server 3 (where the domain control server configuration can reduce a level, the current blogger trial is: Domain control server--2 core 4G database Server (node)--4 core 8G)

2. SQL Server Database (currently blogger with SQL 2016)

Note: The computer name in the real production environment needs to be modified.

1 Start Building Step 1.1: Build a Domain control server

1. Select the established domain control server and modify the domain name.

2. Configure the domain control Ip,ipv6 remove, because the DNS server is installed on the domain control, so the preferred DNS server fills in: 127.0.0.1 loopback address

3. Install the AD Domain service: While installing the domain Control service, the operating system also installs the DNS server

4. Enter the AD Domain Service Configuration Wizard to set the domain name abc.com

5. Set the DSRM password to 123456

The domain controller for the root domain of the first domain tree in the default forest must serve as a global catalog server and must have the DNS service installed, not a read-only domain controller

6. NetBIOS name does not need to be set

7. The AD DS database file path remains the default, and of course, putting the log files and database files on different disks can help improve performance

8. After installing AD DS, the server will be restarted automatically after restarting the server and opening the DNS Manager

You can see that the domain controller win-felbg10uu7f.abc.com has registered the hostname (win-felbg10uu7f) and IP address (192.168.66.155) in the DNS server

9. Check whether the AD domain service and the Netlogon service are starting properly

10. To add domain user dcadmin to AD users and computers, be sure to remember the password for dcadmin, since the second and third sections are required to dcadmin this domain user

Note: If the default Administrator local computer account on the domain-controlled machine is not disabled, after you install the domain control, Administrator local account will be moved from the local SAM local account to the domain account (this account is no longer present in the local account, unless the domain control is downgraded) administrator

At this time other non-domain control machine can use Administrator domain account to log in, but we generally do not use Administrator domain account, but create a new domain user to do, here is another new Dcadmin account

11. Join this domain user to the domain computer group and the Domain Admins group

12. Turn off automatic system updates

Server building domain control with AlwaysOn environment process for SQL Server (i) setting up a domain control server