Install Windows 2012 domain control (for SQL Server AlwaysOn)

Source: Internet
Author: User
Tags domain server

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)

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.