Mirroring Setup Errors

A common error message encountered during mirroring set up is the emphamis error message.

The server network address “TCP://SQLServer: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)

This message can be caused by several reasons.

In this case, the cause of the error message was from another Sql instance on the same Windows server already had an mirroring endpoint set up for port 5022.

This was identified by running the following netstat command.

netstat -aon or netstat -aon | find "5022"

The results showed another Process "2032" under the PID column was already using port 5022.

To identify the conflicting Sql Instance, Sql configuration manager was used along with this PID.

Once the other Sql instance had been identified, the endpoint on that conflicting Sql server was removed and was then able to resume with the Mirroring installation.