SQL Error 1418 - DB Mirroring

Error: 1418 – Microsoft SQL Server – The server network address can not be reached or does not exist. Check the network address name and reissue the command

Fix/Work Around / Solution

1. Make sure the principal and mirror server are standard or enterprise edition.

2. Make sure both have the same service packs ( recommended).

3. Make the firewall on the server are not blocking the port. To check this you can use telnet. Telnet from command prompt as c:/telnet servername portnumber --- this will return blank screen when success else will return message.

4. Make sure the account of MSSQL Server is same in both the servers. i.e., under sql server configuration manager --- click sql server 2005 services --- select sql server ---- right click properties --- built in account or this account. Make sure both have the same.

5. Go to Computer Management >> Service and Application >> SQL Server 2005 Configuration >> Network ConfigurationEnable TCP/IP protocol. Make sure that SQL SERVER port is by Default 1433.

6. Make sure the principal database is backed up and restored in mirror server with norecovery option.

7. Make sure the principal datbase log is backed up and restored in morror server with norecovery option.