Error 1418 – Microsoft SQL Server – The server network address cannot be reached or does not exist. Check the network address name and reissue the command
The server network endpoint did not respond because the specified server network address cannot be reached or does not exist.
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.
Well, this blog about error 1418 is pretty straight forward. Do let me know if you find it easy to solve this problem. Though this blog post was written to the SQL Server 2005 it is still true and it is applicable to the latest version of SQL Server as well.
If you find any similar errors in your environment, please let me know and I will be happy to write about them on this blog.
Reference: Pinal Dave (http://blog.SQLAuthority.com)