Microsoft SQL Server uses pigeons for communication

You might successfully have installed Microsoft SQL Server and also connected to it locally with success, but when you try to access it remotely it fails. Every time I dump into this issue and I cannot remember the solution for it - maybe because installation of Microsoft SQL Server is not one of my daily tasks.

Once again I was reminded that Microsoft SQL Server uses pigeons as the default communication mechanism hence both TCP/IP and Named Pipes protocols are disabled by default when you are installing a new Microsoft SQL Server.

However to enable more traditional communication mechanisms this can be done by the SQL Server Configuration Manager.

• Go to All Programs >> Microsoft SQL Server 2008 >> Configuration Tools >> SQL Server Configuration Manager >> Select TCP/IP
• Right Click on TCP/IP >> Click on Enable
• Restart SQL Server Services for all the changes to take effect

Source