SQL server installation is simple and many IT folks know about it. Still, I am writing this blog post for those people who are not much comfortable with SQL Server. As you know SQL is an important and key server role in Lync & Skype for Business Server. It maintains Skype for Business Back End databases, Archiving and Monitoring databases, and Persistent Chat and Persistent Chat Compliance databases. Installation steps are common across the versions. In this article, I am going to capture installation steps for SQL Server 2014 which will be part of the SQL mirror. This mirror will be used for Skype for Business Back End and Archiving & Monitoring Server databases. As per your requirements and design, you can follow the same steps to create two different mirrors one for Back End databases and another for Archiving & Monitoring databases.
First of all install .Net Framework 3.5 either from GUI or you can use below PowerShell command to install the same. Make sure Windows Server media is connected to sql server, in my case that is connect as H:
Run SQL Server setup from installation media.
Select Installation and click on “New SQL Server stand-alone or add features to an existing installation”
Enter the product key and click on Next.
Accept the license terms and click on Next.
Click on Next.
Ignore this error if you are getting and click on Next.
Click on Next.
Ignore the warning and click on Next.
Select “SQL Server Feature Installation” and click on Next.
For Back End, Archiving, Persistent Chat and Persistent Chat Compliance databases, select the below instance features.
Change the installation path if you want to keep SQL binaries on different location otherwise click on Next.
For Monitoring Server databases, select “Reporting Services – Native” also.
Write the instance name and click on Next.
It is best to use specific service account instead of default.
In Server Configuration tab under “Database Engine Configuration” add users who will have SQL administrative rights.
In Data Directories tab, change the location for databases, log and temp directories as per your design and click on Next.
Use default option and click on Next.
Click on Install.
Once your SQL Server installation is completed. Open SQL Server Studio Manager to cross verify the installation and connectivity.
Use the same installation step for second server. While for witness server either you can install SQL Server express edition or can use any other existing SQL instance.