SQL Server is installed after always on group configuration

You need to open the Windows Firewall inbound rules on the necessary ports for SQL Server , such as the TCP-1433 port.

Special Note: Since the AG is required to use the TCP-5022 port by default, the port must be guaranteed to be open in Windows Firewall, allowing its inbound access.

After you confirm that the SQL Server installation is complete

Configure the SQL Server 2016 Database Engine service for the high Availability group.

1) from the Start menu, tap All Programs-Microsoft SQL Server-configuration tools to openSQL Server Configuration Manager.

2) In the console, click theSQL Server Services node, right-clickSQL Server (MSSQLSERVER) in the right-hand window, and select Properties from the context menu.

3) in the pop-up window, select "enable AlwaysOn availability groups" in the "AlwaysOn High Availability" tab. Click "Confirm".

4) in the pop-up warning dialog box, prompt that the modification requires the SQL Server Database engine service to be restarted to take effect, click OK.

5) Right-click SQL Server (MSSQLSERVER) again and select Restart in the context menu to perform a restart on the database engine.

6) in order to avoid complex permission settings when implementing an AlwaysOn group, it is recommended that the associated SQL service (such asSQL Server Database Engine service) initiate the login as the default "built-in account" to the specified domain account.

< Span lang= "en-us" >

7) It is recommended that the domain account be granted SQL Server logon rights for each node and that each node server account be assigned as a SQL Server login account

The above steps perform the same operation on the sql01/02.

Iv. creating a configuration high Availability group

There are three ways to create a high Availability Group: Wizard mode, dialog box mode, and scripting, which is described as an example of the Saplink as the primary database created on the first wizard.

1 , creating a configuration database for a high availability group

To use the wizard to create a high availability group, you must have a qualifying database exists for related operations. So what are the criteria for the database to meet the conditions?

1) The recovery model of the primary database must be the "full" recovery model.

A full backup of the primary database has been made

2) requires a shared path to be provided to the backup package store, and allows all node servers (SQL Server Database Engine service login account) to have read-write access through the UNC path.

2 , using the wizard to create a new high availability group

1) from the Start menu, tap All Programs-Microsoft SQL Server-configuration tools to openSQL server Management Studio.

2) Expand theAlwaysOn High Availability node, right-click Availability groups, and in the context menu, select New Availability Group Wizard.

3) Click "Next" On the "Introduction" page.

4) Specify a name for the high availability group that you want to create.

5) Select the database that meets the criteria for joining the High Availability group and click Next.

6) to add additional to the High Availability groupsq L server server node is a replica. Click the "Add a Copy" button to add the desired sql server server, and specify the initial role as either primary or secondary. Up to optional 2 Replicas for automatic failover, Both replicas will use synchronous-commit availability mode at the same time. Supports up to 3 copy for synchronous-commit availability mode , you must force a manual failover if you use asynchronous commit. For a readable secondary replica setting, you can choose whether it is readable or read-only, and you need to be aware that only the primary database copy is writable.

7) Click on the "Endpoints" tab to set the endpoint URL for the high availability group . You can use the default settings.

8) In Backup preferences, specify the node that is the backup copy. The default is to make a backup in the preferred secondary replica. You can specify preference by replica backup priority. All nodes are 50 by default .

9) Create a listener for the High Availability group, specify the Host name and port of its DNS name, recommend that the IP address use a static IP, and add a new cluster IP as a high availability group so that you can specify the SQL The default port of server 1443 to simplify the configuration of client access.

Initialize the data synchronization preferences, it is recommended that you select full and specify the UNC share path that you created earlier . Click "Next"

One) Verify that the High Availability group creation requirements are met, and if the results are all green tick, click "Next"

check and confirm the previous configuration information, if it is correct, click "Done". In addition, you can save a set of scripts to diagnose faults in steps.

Wait for the wizard to complete the creation of the SQL Server 2016 high Availability group.

SQL Server is installed after always on group configuration