Category Archives: SQL Server 2008

SQL Server 2008 Database Mirror Setup Fails

Sometimes setting up Database Mirroring or Replication from one database to another for disaster recovery or fault tolerance etc. can be tricky.¬† I ran into an issue where the mirror kept failing, even after the full backup [from the Principal] and restore [to the Mirror] of the database and most recent transaction logs completed successfully. I encountered ‘handshake failed’ and encryption algorithm errors.

It was indicated in Event ID’s 1474 and 1433.

Fascinating! I elaborate on a resolution here.