In this Multi Part Article, I going to show you how to setup SQL AlwaysOn whish is very much supported for Skype For Business.

How to install SQL 2014 with SQL AlwaysOn for Skype for Business-Part 1

How to install SQL 2014 with SQL AlwaysOn for Skype for Business-Part 2

Okay, It is very interesting and without further talks, Let’s Begin,

‎

For SQL Always On, You need Dual Network Cards one of them used for Replication.

Both NICs should be in two Different Subnets

1

For replication Network Card, You should not use the Gateway.

2

Go to Server Manager and Add Roles and Features

3

4

5

6
Since we are not going to install any Roles click Next to Continue
7
Select Failover Clustering and .NET Framework 35 Features
8
Specify the Source path and click Install
9
10

11

12
13
Use the above steps and Install in second Server as well.

Go to Tools and click on Failover Cluster Manager
14
Click on Create Cluster
15
16
Select the Servers and click Next

17
18

19

20

21

22
Select the IP Address for SQL Cluster and click Next
23
24

25

26

27
Since the Cluster is created with Even Numbers, We need to add the Witness server
Before we go for Configuration, We need to create Fileserver share and provide Full Control Permission for SQL Cluster name
28
29
Right click on SQL Cluster and Configure Cluster Quorum Settings
30

31
Select the Quorum Witness and click Next
32
Select Configure a File Share Witness and click Next
34
35
Select the Server and Chose the File share Path which we created and assigned permissions

36
37
38
39
40
So far so Good, Windows Failover is created. Now we can go ahead and install the SQL Server.
How to install SQL 2014 with SQL AlwaysOn for Skype for Business-Part 1
How to install SQL 2014 with SQL AlwaysOn for Skype for Business-Part 2

Leave a Reply

Your email address will not be published. Required fields are marked *