If you are going to deploy a High Availability solution which you can use for Lync Server 2013, you will need to deploy a SQL 2012 mirroring cluster.
This is a guide on how to deploy the two primary server SQL 2012 servers.
I have in this example I have created two SQL Servers with these specs:
- 4 x CPU
- 16 GB RAM
- 100 GB System Drive
- 300 GB Data Drive
- Windows Server 2012
You could also have 100 GB Log drive.
SQL Server loves performance and you should always place in a fast storage system, and give it a lot of memory.
Before you start the installation, you should create an account in AD, with a strong password, which never expires (you should manually control when you change the password).
The account will later in the guide running the SQL Services.
The AD account should be member of the local Administrator group on each server.
To install SQL 2012 you mount the SQL 2012 server CD in the first server.
Start the setup and click Next
Select the “New SQL Server…”
Type a Product Key and Select Next
Read ALL the license terms before you accept it J and select Next
Select “SQL Server Feature Installation” and select Next
Select the below features
And these and select Next
When the check is complet Select Next
Make a new Named instance – call it RTC and Select Next
Select an domain account for the below services
Choose mixed mode and type a strong SA password. You should also add administrator accounts or even better administrator groups which has access to manage the SQL.
On the Data Directories, choose where to place the databases and log files and Select Next
Select “Install Only” to the reporting services and Select next
At the next screen you can save an ini file which you can use on node 2, to make the exact same installation.
After a while the installation should complete and you can close the installation.
When you are going to install SQL on node 2, you can either do it all again, or you can do it the easy way if you remembed to save an installation ini file.
Mount the installation cd on the server and open an command prompt with administrator rights.
Run this command from the CD.:
After a while the installation is complete.
You should the run Windows update to install the latest servicepack and fixes for both windows and SQL server.
Normally you should run it a couple of times.
In the next guides, we will look at how to install the witness server, and configuring SQL and Lync.