top of page

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.

SQL Installation

Select New SQL Server Stand-alone and click Next


Since I am installing in Test lab, I going with the Evaluation Version






Select Database Engine Services and management Tools-Basic, Management Tools-Complete




Set Startup Type Automatic and Click Next

Select the Administrator Account and Click Next






Open SQL Server Configuration Manager and Click on SQL Server Properties

Select Enable AlwaysOn Availability Groups and Click Apply


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


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


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





86

You can see the Second server added and database also synchronized. 

1 view0 comments

Recent Posts

See All
bottom of page