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.
Taking further, you need to have a service account for running both the SQL servers.
Mirroring configuration then needs that account for the set up.
Also , check if you can connect to either of the SQL servers from INSIDE either servers through SSMS.
Make sure the ports for SQL server are bi directionally open.