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

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

SQL Installation
41
Select New SQL Server Stand-alone and click Next
42
43
Since I am installing in Test lab, I going with the Evaluation Version
44
45
46
47
48
49
Select Database Engine Services and management Tools-Basic, Management Tools-Complete
50
51
52
53
Set Startup Type Automatic and Click Next
54
Select the Administrator Account and Click Next
55
56
57
58
59
60
Open SQL Server Configuration Manager and Click on SQL Server Properties
61
Select Enable AlwaysOn Availability Groups and Click Apply
62
63

 

 

Restart the SQL Service once AlwaysOn is applied.
64

Open SQL Management console
65

 

Click Connect
66

Right Click on databases and Click on New Database to a Test Database
67

Here is the Test Database with Database Name: SFB-ON
68

Follow the above steps and install SQL in Second Server as well.
Right Click on AlwaysOn High Availability and Select New Availability Group Wizard
69
70

Click Next
71

SKYPE-AON is the name and Click Next
72

You would get Full Back is required Alert if you have not taken the back
73

Here I have not taken the Backup here before hence processing the Backup by right Clicking on Test Database which we created and click on backup
74

Click OK to Backup
75
76

Once Backup is completed, Click on Refresh
77

Now you will see the Status is Meets prerequisites, Click Next
78

Add Replica Servers
79

Select Automatic Failover and Synchronous Commit and click Next
80

Without fail add the Listener Name: SFBAON-Listner and IP address for it and Click Next
81

Select the File share which we have created during the Cluster Creation
82
83
84
85
86

You can see the Second server added and database also synchronized. 87
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

Author Bio

Radhakrishnan Govindan

Leave a Reply

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