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

The server network endpoint did not respond because the specified server network address cannot be reached or does not exist.

Solution:

Step 1. Your system Firewall should not block SQL Server port.

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

Just to make sure follow one more step which may or may not be necessary.

Step 3. Go to Computer Management >> Service and Application >> SQL Server 2005 Configuration >> Client Configuration
Enable TCP/IP protocol.