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 e.name = N'EndPoint_name')
DROP ENDPOINT [EndPoint_name]
GO
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 e.name = N'EndPoint_name')
DROP ENDPOINT [EndPoint_name]
GO
Comments
Post a Comment
Please avoid link comments