Can not connect to SQL Server

I installed SQL Server 2005 (server and client components) on Windows Server 2003 with SP1. I can connect to this sql server from any other machine. However, I can not connect from this machine to sql servers on other machines. I have tried named pipe and TCP/IP. Neither of them works. The error message is can not establish connection. Any suggestion?

Thanks,

What is the exact error message ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

Here is the error message:

An error has occured while establishing a connection to server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Cound not open a connection to SQL Server) (Microsoft SQL Server, Error 53)

Had enabled the remote connection from other server and can connect that server from other machines.

Thanks,

|||Is a firewall (Perhaps the WIndows default one) installed and configured on the server ? Perhaps then outgoing traffic on the ports is restricted.

-Jens.|||

Also, if you're connecting to a named instance, make sure that you're either specifying the port number in the connection string or you have SQL Browser running on the server machine.

Thanks,
Il-Sung.