locked
Database mirroring connection error RRS feed

  • Question

  • Hi all,

    There used to be series of messages in the error log duirng mirror connection failure

    Database Mirroring connecton error 2....

    Databae mirroing connection error 3

    Database mirroring connection error 4...

     

    is there any significan to the connection error numbers (like 2/3/4 etc)?

     

     

    Monday, November 8, 2010 5:54 PM

Answers

  • They just represent different types of connection errors, i.e. 2 relates to a DNS problem, 4 is an error recieving data (often permission related), 5 is connection handshake error etc. There is a good article on BOL which goes through the possible mirroring errors...

    http://technet.microsoft.com/en-us/library/ms189127.aspx

     

    Thanks


    /Neil Moorthy - Senior SQL Server DBA/Developer (OCA 11g, MCITP (2005), MCAD) Please click the Mark as Answer button if a post solves your problem
    Monday, November 8, 2010 11:15 PM

All replies

  • They just represent different types of connection errors, i.e. 2 relates to a DNS problem, 4 is an error recieving data (often permission related), 5 is connection handshake error etc. There is a good article on BOL which goes through the possible mirroring errors...

    http://technet.microsoft.com/en-us/library/ms189127.aspx

     

    Thanks


    /Neil Moorthy - Senior SQL Server DBA/Developer (OCA 11g, MCITP (2005), MCAD) Please click the Mark as Answer button if a post solves your problem
    Monday, November 8, 2010 11:15 PM
  • while configuring mirroring mainly 3 kinds of error arises

    1. FQDN not support

    drop end points and recreate end points

    2. Trace flag not enable

    check the trace status globally

    3. database names may not same.

     

    Wednesday, November 10, 2010 2:55 PM