miércoles, 28 de noviembre de 2012

The server network address “TCP://SQLServerName:5022″ cannot be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Server, Error: 1418 )

The server network address “TCP://SQLServerName:5022″ cannot be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Server, Error: 1418 ).

If this error occurs when you're trying to create a mirror, check this points:

  • Restore backup at secondary server has to be with NORESTORE option.
  • All log backup must be restored (Probably some job of SQL SERVER AGENT makes Transaction Log Backup, ensure that last log backup is restored in secondary too).
  • GRANT CONNECT ON ENDPOINT::Mirroring TO Public (I think with domain user that runs service account it's enough, but it doesn't work for me, so, PUBLIC, works).
  • Maybe Firewall block the Port Number, try to connect, with TELNET for example.

I hope it helps.

1 comentario:

  1. I found a simple solution when faced with this issue and after all the ip address were changed in my network:
    Stop and start the endpoints in both the Principal and Mirror

    ResponderEliminar