A Unified Communication Blog
Get Adobe Flash player


In this guide I will continue the installation of the SQL 2012 Mirroring cluster which I will use for my Lync 2013 High Availability installation.

You can see the first part here


When using an SQL mirroring cluster you will need a witness server – This is how to install that.


The specs for my witness server is:

  • 1 x CPU
  • 4 GB RAM
  • 100 GB Disk
  • Windows Server 2012

Download SQL 2012 Express from Microsoft here: http://www.microsoft.com/en-us/download/details.aspx?id=29062

Double click on the installation file


Choose “New SQL Server….”


Read all the license terms before you accept it and Select Next


Select Next


Choose Default and Select Next


Select Next


Select Mixed mode and type a strong SA password. You should also add administrators or even better administrative groups, which must be able to manage the server.

Select Next

Continue the last screens and wait for the installation to complete.

When the installation is finished you should go to windowsupdate and update both windows and sql server with the latest servicepacks and fixes.

A couple of reboots is normally reqiured.


Next we will create a share on the witness server, which the mirroring cluster will use as well.


Create it on the C: drive, and name it something use full like LyncMirroring


Right click on the new folder and select Properties

Click on Advanced Sharing, and the give it a share name

Click on Permissions and give Everyone Full Control

Click OK twice and select the security fane

Add the two SQL cluster nodes computer account to the permissions and give them full control


Press OK to save the permissions and then close


You should now a two SQL 2012 mirroring servers and a witness server.

In the next guide we will be looking at configuering the SQL servers, before we can use it in Lync 2013.



Lync 2013 High Availability

Part 1: http://exchangepro.dk/2013/08/28/install-a-sql-2012-mirroring-cluster-for-use-with-lync-2013-part-1/

Part 3: http://exchangepro.dk/2013/09/01/configure-a-sql-2012-mirroring-cluster-for-use-with-lync-2013-part-3/

Part 4: http://exchangepro.dk/2013/09/14/deploy-a-lync-2013-file-store-part-4/

Part 5: http://exchangepro.dk/2013/09/19/prepare-your-servers-for-lync-server-2013-ha-part-5/

Part 6: http://exchangepro.dk/2013/09/21/creating-the-lync-server-2013-ha-topology-part-6/

Part 7: http://exchangepro.dk/2013/09/30/install-the-first-frontend-server-part-7/

Part 8: http://exchangepro.dk/2013/10/06/update-the-frontend-server-part-8/

Part 9: http://exchangepro.dk/2013/10/13/install-the-office-web-servers-part-9/

Part 10: http://exchangepro.dk/2013/10/21/deploy-the-director-servers-in-lync-2013-ha/

Part 11: http://exchangepro.dk/2013/10/25/install-the-access-edge-ha-servers-part-11/

Part 12: http://exchangepro.dk/2013/11/05/deploy-reverse-proxy-using-kemp-hardware-load-balancer-part-12/

Part 13: http://exchangepro.dk/2013/11/14/adding-additional-frontend-servers-to-lync-ha-part-13/

Part 14: http://exchangepro.dk/2013/11/26/setup-load-balancers-for-the-internal-lync-servers-part-14/

Part 15: http://exchangepro.dk/2013/11/26/load-balance-the-office-web-apps-server-part-15/

Part 16: http://exchangepro.dk/2013/11/26/load-balance-the-lync-frontend-web-services-part-16/

Part 17: http://exchangepro.dk/2013/11/28/load-balance-the-lync-frontend-services-part-17/

Part 18: http://exchangepro.dk/2013/12/15/load-balance-the-lync-director-servers-part-18/

Part 19: http://exchangepro.dk/2013/12/15/load-balance-lync-access-edge-internal-nic-part-19/

Part 20: http://exchangepro.dk/2013/12/29/load-balance-lync-access-edge-external-nic-part-20/

One Response to Install a SQL 2012 Witness Server for use with Lync 2013 – Part 2

  • Awesome post! I spent at least an hour Googling on this topic an there is mass confusion out there on what version of SQL server 2012 will or will not work for the witness server. You cleared it all up in one easily understood post. Well done!

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>


Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 77 other subscribers

Follow me on Twitter