Use the same installation step for second server. Open SQL Server Studio Manager to cross verify the installation and connectivity. Once your SQL Server installation is completed. In Data Directories tab, change the location for databases, log and temp directories as per your design and click on Next. In Server Configuration tab under “Database Engine Configuration” add users who will have SQL administrative rights. It is best to use specific service account instead of default. Write the instance name and click on Next. Select “SQL Server Feature Installation” and click on Next.įor Back End, Archiving, Persistent Chat and Persistent Chat Compliance databases, select the below instance features.Ĭhange the installation path if you want to keep SQL binaries on different location otherwise click on Next.įor Monitoring Server databases, select “Reporting Services – Native” also. Ignore this error if you are getting and click on Next. Select Installation and click on “New SQL Server stand-alone or add features to an existing installation”Īccept the license terms and click on Next. Run SQL Server setup from installation media. Make sure Windows Server media is connected to sql server, in my case that is connect as H:

Net Framework 3.5 either from GUI or you can use below PowerShell command to install the same.

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.įirst of all install. This mirror will be used for Skype for Business Back End and Archiving & Monitoring Server databases. In this article, I am going to capture installation steps for SQL Server 2014 which will be part of the SQL mirror. Installation steps are common across the versions. It maintains Skype for Business Back End databases, Archiving and Monitoring databases, and Persistent Chat and Persistent Chat Compliance databases. As you know SQL is an important and key server role in Lync & Skype for Business Server. Still, I am writing this blog post for those people who are not much comfortable with SQL Server. SQL server installation is simple and many IT folks know about it.

Skype for business 2015 install