Install SQL Server (for AlwaysOn)

SQL Server AlwaysOn is based on SQL Server 2012 and has been greatly increased, such as the ability to create hybrid solutions for AlwaysOn availability groups through the Add Azure Replica Wizard, and the maximum number of secondary replicas from 4 increased to 8; When disconnecting from the primary replica or during a lack of cluster quorum, readable secondary replicas are now available for read workloads; a failover cluster instance (FCI) can now use cluster Shared volumes (CSV) as a cluster shared disk; A new system function is provided sys.fn_hadr_is _primary_replica and a new DMV sys.dm_io_cluster_valid_path_names; The following DMV has been enhanced and now returns FCI information: Sys.dm_hadr_cluster, sys.dm_ Hadr_cluster_members and Sys.dm_hadr_cluster_networks and so on. This article describes the installation process for AlwaysOn pre-deployment SQLserver2014 for your reference.

First, SQLserver2014 installation and hardware requirements and installation instructions

    https://technet.microsoft.com/zh-cn/ms143506.aspx    [安装Windows 2012域控(For SQLServer 2014 AlwaysOn)](http://blog.csdn.net/leshami/article/details/51180359)    [Windows 2012配置故障转移(For SQLServer 2014 AlwaysOn)](http://blog.csdn.net/leshami/article/details/51218021)

Second, initialize the OS SID (if virtual machine cloning is used) 1) Initialize SID

If you cloned Windows Server 2012 by using cloning, modify the hostname, restart
Then use Sysprep to reset the SID
Click Start, run, enter Sysprep

2) Modify the IP address, gateway and DNS, and then join the computer to the domain

3) Add a domain user to the local Administrators group

Open Computer Management, select Local Users and Groups, double-click Administrators, click "Add", as

Third, install. Net 3.5

Open Server Manager
Click on the "Manage" menu and select "Add Roles and Features"
Click Next, select Role-based or feature-based installation, click Next
Select the local server, click Next until the Feature module, select. NET 3.5
Before installing, you need to specify the installation source

Iv. mounting SQLserver20141) type of installation

SQL Server AlwaysOn can be run on a failover cluster-based or single-instance basis, and for simplified installation, this article is based on a single instance.

2) Enter the key

3) Accept the license terms

4) Whether to turn on the update

Not open here

5) Click Next

6) Installation rules and inspection

Here we shut down the firewall, so there is a warning, ignoring

7) Set the role

Select SQL Server Feature Installation

8) Installation Function selection

Select as needed, basic installation In addition to the Database engine service, it is also a good idea to install the Client management tool

9) configuration of the instance

This is selected as the default instance, and if it is a named instance, you need to specify the appropriate instance name

10) Start account and self-start selection

Leave the default here, and then modify when you turn on AlwaysOn

11) Sorting rules

12) engine Configuration

Includes authentication and data catalog, and FileStream, etc.

13) Installation Checklist

14) Start Installation to completion

Install SQL Server (for AlwaysOn)