Office365 Exchange Hybrid part ADFS back-end SQLAlwayson (1)

The previous articles share with you the deployment process of SQL failover clustering. The high availability of ADFS backend database SQL can be cluster or alwayson. Of course, this is for SQL database to achieve high availability. It is not limited to any system using SQL database on ADFS, such as Skype for Business Server, SharePoint Server,System Center, and so on.

With the implementation experience of SQL failover clustering, Alwayson is relatively easy to do. Or prerequisites:

1. The SQL Server node must be an enterprise version

2. Windows failover clusters must be deployed (but do not use shared storage)

3. Of course, it should be implemented based on the domain.

Understand the above requirements and get started. For the implementation of Windows failover clustering, please refer to the Office365 Exchange Hybrid article ADFS back-end SQL Cluster (3), but it is different from the reference section, mainly the configuration of cluster quorum, which is as follows:

Select "Select Arbitration Witness"

Choose a shared folder as a witness

Determine the shared folder path

Click next to configure the arbitration witness.

After completing the arbitration witness, open the second SQL Server, open the failover cluster administrator, and connect to the currently created Windows failover cluster

After the completion of the above steps, the most basic part is completed, and then you need to install the SQL database on the two SQL Server servers respectively. The installation process is no different from the usual installation of a stand-alone version of SQL. We will not describe it too much here, but the installation features of the two SQL should be the same.

The next article will share the key implementation process of Alwayson.