Mirroring is dead. Long live mirroring. While it will no longer be included in future versions of SQL Server, I still come across instances I have to support and thus am making some notes. Occasionally, when setting up mirroring, you may get the following error.
The server network address “TCP://SQLServer: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. (Microsoft SQL Server, Error: 1418)
I have found some common scenarios include:
- Insufficient permission on both nodes. Make sure the service account for each SQL Server instance has rights to the partner instance. Seems simple enough, but this was an issue for me just last month.
- The log backup has not been applied to the partner/mirrored instance. While sometimes it might let you set up without taking a transaction log backup and applying it on the partner database, more often than not it requires it.
Check out Robert Davis’s post for more helpful information if you are stuck.