Microsoft has introduced many highly available technologies for SQL Server, such as early replication, later log shipping, database mirroring, SQL Server clustering, and so on. In SQL Server 2012 There is also a killer, and Oracle has a fight! SQL Server AlwaysOn consolidates Windows clusters, database mirroring, increased read and write separations, and more. SQL Server operations require support for Windows domain control, which is described in this article as configuring a domain-controlled environment for SQLSERVER2012 AlwaysOn, as described below.
I. Configuration Environment description
based on VMware Workstation 12, 4 virtual machines, one domain control, 3 SQL nodes, using NAT mode, turn off DHCP Machine name IP GateWay DNS-------------- -------------- ------------- --------------SQLDC 192.168.171. - 192.168.171.2 127.0.0.1SQLnode1 (Master) 192.168.171. + 192.168.171.2 192.168.171. -SQLnode2 (supplemented) 192.168.171. A 192.168.171.2 192.168.171. -SQLnode3 (supplemented) 192.168.171. at 192.168.171.2 192.168.171. -ALWAYSONWSFC 192.168.171. -
Second, configure the virtual network
Configure a virtual network
Set up a VMware virtual network
Click on the "Edit" menu and select the Virtual network editor, as
Third, installation Windown DataCenter (slightly)
If the virtual machine is in a bridging mode, change the virtual machine NIC to NAT mode
admin password [email protected]
Iv. configuring IP and modifying host names
1. Right click on the taskbar "network adapter" icon, select Open "Network and Sharing Center", click "Change adapter Settings", as below, enter the corresponding IP address
2, modify the hostname, and restart, as follows
V. Install AD and DNS
1. Click the taskbar Server Manager, open the Server Manager dashboard, click the Manage menu, select Add Roles and features, click Next
Select Role-based or feature-based installation, click Next
2. Tick the Active Directory domain server, and the DNS server
3. Then click Next, all the way next, and finally click Install, and then click the Close button when the installation is complete.
Six, configure the domain control
1. Click the exclamation point of the Server Management panel, for example, and then click Promote this server to a domain control server
2. Add a new forest, as the following example, added as Ycdata.net
3. Select the domain Name System (DNS) server. By default, the global catalog is selected. and set the Active Directory to restore the password after clicking Next
4. DNS Option prompt
5. Set NetBIOS name, leave default value here
6, set the adds position, keep the default value
7. Below is the configuration checklist, click Next
8. Perform prerequisite checks, click Install, and automatically restart after installation is complete
9, restart the use of the domain, administrator login
10. View ad domains and trust relationships, and view ad sites and services, click the appropriate menu
Vii. Adding Domain Users
1, the Domain users added here, mainly for the subsequent installation and management of SQL Server to prepare
Server Manager panel, click Manage, click AD Users and Computers
Right-click the domain, select New, select group
Enter a group name, as in this case Sqlteam
2. Right click on "Users", select "New", select "User"
3. Enter User name
4. Enter the password
5. Create user complete
6. Adding users to a group
7, select the group, add complete
After the above work is completed, you will need to install and configure Windows Failover services, as detailed in the following articles.
Install Windows 2012 domain control (for SQL Server AlwaysOn)