Database Mirroring configuration RRS feed

  • Question

  • I have installed 3 sql server 2014 enterprise edition  in my laptop (windows 10). 

    I have create a database on server1 and take a full backup and also transaction log back and restore in server 2 with same datbase name with no recovery option. When click start Mirroring button, i am getting the below error massage.

    Error 1418, The network address can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational.

    I have tried 10 times but not configured, Please help

    Monday, August 12, 2019 4:18 PM

All replies

  • You may have to post your configuration screens for us to give us more details - But for now, on the mirroring wizard screen where you configure the endpoint name and port, are you choosing a different port other than the Principal (5022)?  Like 5023 for the Secondary?  The endpoint name should be the same for both Primary and Secondary...
    Monday, August 12, 2019 4:56 PM
  • Would you please refer to https://techyaz.com/sql-server/troubleshooting/fix-error-1418-the-server-network-address-cannot-be-reached-or-does-not-exist/

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Tuesday, August 13, 2019 8:46 AM