Comments on: Setup Database Mirroring in SQL Server 2012 with Certificates https://tecadmin.net/setup-database-mirroring-sql-server/ How to guide for System Administrator's and Developers Thu, 19 May 2016 09:10:42 +0000 hourly 1 https://wordpress.org/?v=6.1.1 By: User https://tecadmin.net/setup-database-mirroring-sql-server/#comment-2660 Thu, 19 May 2016 09:10:42 +0000 https://tecadmin.net/?p=2580#comment-2660 You have a few errors in your scripting. For instance, to enable database mirroring, you need to run the alter command on the mirror instance first and then the principal instance.

Also, when creating the users using the certificates which were created in the previous step, you are not consistent with the naming on the certificates (i.e. certificatesprincipal_cert.cer vs. certificateprincipal_cert.cer). To help laymans like me banging their head on the wall, I would suggest making these updates. Otherwise the instructions were very simple to follow.

]]>