Thursday, June 11, 2015

Troubleshooting MS SQL 2005 Mirroring

Setup:

Principal: Backup database FULL recovery

Mirror: restore database with NORecovery mode

Mirror : restore all transaction logs

Principal : Right click database and click mirroring 

Principal : add Principal DNS name and Mirror DNS name

Principal: click start mirroring

Troubleshooting:

  • GRANT CONNECT ON ENDPOINT::Mirroring TO public
  • Turn off Windows firewall (normal port is 5022)
  • Delete endpoints (the end points are on both Principal and Mirror)
  • use IP addresses instead of FQDN
  • Add user to Sysadmin Server Role

No comments:

Post a Comment