Sunday, March 16, 2014

Start SQL 2008 R2 Mirroring Error

Problem:
Cannot start SQL mirroring between the Principle and Mirror Servers
Cause:
The server network address "TCP://ServerName.domainname.com: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)

Resolution:
1. Make sure you restored new full backup on Mirror server (with norecovery mode)

 2. Try to connect mirror instance from principal server and vice versa ( to make sure mirror is contacting principal and principal is contacting mirror)

Verify the listener port using the below command
telnet sqlservername portnumber

 3. Issue the below command from both principal and mirror instances

Grant connect on endpoint::mirroring to domain\account (If this does not works, use the below command)
Grant connect on endpoint::mirroring to public