• SQLisAwE5OmE - Friday, January 12, 2018 2:37 PM

    Hi Team,

    I tried setting up DB mirroring between PRD & DR side and I am getting the below error.
    I checked firewall, all good, connected via telnet from PROD to DR and vice versa.
    Msg 1418, Level 16, State 1, Line 1
    The server network address "TCP://199.199.99.99:5022" 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.

    Any idea what else can cause this problem?.....I have had this error many times and each time I troubleshoot the issue/resolution is different, so I couldn't find the exactly solution any time.

    Both my PROD and DR SQL Server running under "Local Systems", not sure if this is the problem?

    Can someone provide any hint.  Thanks.

    can you telnet to the port and ip from the partner server?
    verify if the local firewalls are enabled and also whether there is a corporate firewall between the 2 endpoints

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

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