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.