May 11, 2014

Error no:1418 on Mirroring in SQL

The server network address "xxxxx" can not be reached or does not exist. Check the network address name and reissue the command.

Pls check endpoints on all servers using
SELECT * FROM sys.endpoints

If 1418 error: check it these, duplicate end points exists, tcp/ip enabled or not, check editions principal and mirror, windows firewall off, check login not created in mirror instance.

How to delete duplicate end points if exists ?

IF EXISTS (SELECT * FROM sys.endpoints e WHERE = N'EndPoint_name')
DROP ENDPOINT [EndPoint_name]

No comments:

Post a Comment