Microsoft has launched a number of 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 the Windows cluster, database mirroring. Added read-write separation, and so on. SQL Server implementation requires Windows domain control support, described in this article is for SQLserver2012 alwayson configuration domain control environment, detailed described below description.
I. Configuration environment Descriptive narrative
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, for example
Third, installation Windown DataCenter (slightly)
Assuming that the virtual machine is in a bridging mode, change the virtual machine NIC to NAT mode
admin password [email protected]
Iv. Configuring IP and changing host names
1. Right click on the taskbar "network adapter" icon, select Open "Network and Sharing Center", click "Change adapter Settings", for example, enter the corresponding IP address
2, change the hostname, and restart, such as the following
V. Install AD and DNS
1. Click taskbar "Server Manager". Open the Server Manager dashboard, click the Manage menu, select Join Roles and features, click Next
Select Role-based or feature-based installation. Click Next
2. Tick Active Directory domain server. and DNSServer
3, and then click Next. The next step. Finally, click Install. When you are finished installing, click the Close button
Six, configure the domain control
1. Click the exclamation point section of the Server Admin panel. For example, and then click Promote this server to a domain control server
2, join the New forest, such as the following demonstration sample, joined as Ycdata.net
3. Select Domain Name System (DNS) server. By default, the global catalog is selected. and set the active folder to restore password after you click Next
4. DNS Option prompt
5. Set NetBIOS name, leave default value here
6, set the adds position, keep the default value
7, the following is the configuration checklist, click Next
8. Perform prerequisite checks. Click Install, and you will be actively restarted after installation
9. Restart use domain, administrator login
10. View the ad domain and trust relationships. and view ad Sites and services, click on the corresponding menu to
Vii. Join a domain user
1. Join the domain user here. Mainly for SQL Server installation and management preparation
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. Input username
4. Input password
5, the creation of the user completed
6. Join the user to the group
7. Select group, Join complete
After completing the above work, you need to install and configure Windows Failover services. See the article in detail.
Install Windows 2012 domain control (for SQL Server AlwaysOn)