SQLserver2014 (ForAlwaysOn) Installation graphic tutorial, sqlserveralwayson

SQLserver2014 (ForAlwaysOn) Installation graphic tutorial, sqlserveralwayson

On the basis of SQLserver 2014, SQLserver 2012 AlwaysOn greatly increased. For example, you can use the "add Azure copy wizard" to simplify the creation of hybrid solutions for AlwaysOn availability groups; the maximum number of secondary replicas is increased from 4 to 8. When you disconnect from the primary replica, or when the cluster arbitration is missing, the readable secondary replicas can now be used to read workloads; the failover cluster instance (FCI) can now use the cluster shared volume (CSV) as the cluster shared disk; a new system function sys is provided. fn_hadr_is_primary_replica and a new DMV sys. dm_io_cluster_valid_path_names; the following DMV has been enhanced and FCI information is returned: sys. dm_hadr_cluster, sys. dm_hadr_cluster_members and sys. dm_hadr_cluster_networks And so on. This article describes the installation process of SQLserver2014 before AlwaysOn deployment for your reference.

I. Requirements for installing software and hardware in SQLserver2014 and installation instructions

Https://technet.microsoft.com/zh-cn/ms143506.aspx
[Install Windows 2012 Domain Controller (For SQLServer 2014 AlwaysOn)] (http://blog.csdn.net/leshami/article/details/51180359)
[Windows 2012 configure Failover (For SQLServer 2014 AlwaysOn)] (http://blog.csdn.net/leshami/article/details/51218021)
Virtual Machine cloning ">

Ii. initialize the OS SID (if the VM clone is used)

1) initialize SID

If the clone method is used to clone Windows Server 2012, modify the Host Name and restart

Then use sysprep to reset SID

Click Start, Run, and enter sysprep

2) modify the IP address, Gateway and DNS, and then add the computer to the domain

3) add domain users to the local administrator Group

Open Computer Management, select local users and groups, double-click Administrators, and click Add, as shown in

3. Install. Net 3.5

Open Server Manager

Click the manage menu and select Add role and function"

Click Next, select role-based or function-based installation, and click Next"

Select the local server and click "Next" until the function module, and select ". NET 3.5"

Before installation, you must specify the installation Source

Iv. Install SQLserver2014

1) installation type

SQLServer AlwaysOn can run on failover-based clusters or on a single instance. To simplify installation, this document is based on a single instance.

2) enter the key

3) accept license terms

4) Whether to enable update

Not Enabled here

5) Click Next

6) Installation rules and check

We disabled the firewall here, so there is a warning, ignore

7) set roles

Select SQLserver function Installation

8) Select the installation Function

Select as needed. In addition to the Database Engine service, it is best to install the client management tool.

9) instance Configuration

Select the default instance. If the instance is named, you must specify the corresponding instance name.

10) Start account and self-start Selection

The default value is retained here, which can be modified when AlwaysOn is enabled.

11) sorting rules

12) engine configuration

Including identity authentication and data directory, and FILESTREAM

13) installation list

14) Start installation to complete