error 1418 when I start database mirroring

  • Hi All,
    I am able to create end point while implementing database mirroring, but when I try to start mirroring I get error 1418 (the server network address "TCP:servername.domainname:5022" cannot be reached or does not exists) 

    I have enable the TCP/IP, named pipe protocoal, restored the database in recovery mode, database in full recovery. windows firewall is also off.

    Please suggest if I am missing someting somewhare

  • Duplicate of topic: https://www.sqlservercentral.com/Forums/1874393/error-1418-when-I-start-database-mirroring

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • Hi Thom,
    The test in double quote is not the sql quote but the error message I am getting

    Sam

  • This was removed by the editor as SPAM

  • sam_s - Thursday, May 4, 2017 3:55 AM

    Hi All,
    I am able to create end point while implementing database mirroring, but when I try to start mirroring I get error 1418 (the server network address "TCP:servername.domainname:5022" cannot be reached or does not exists) 

    I have enable the TCP/IP, named pipe protocoal, restored the database in recovery mode, database in full recovery. windows firewall is also off.

    Please suggest if I am missing someting somewhare

    Check which network connection mirroring is trying to communicate over.
    Is the endpoint set to use IP_ALL?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply