Cant connect to remote server

I recently reinstalled SQL Server 2005 on a new computer, and now I can't connect to remote SQL servers for some reason.

When trying to access the remote server with SQL Management Studio or DTS I get the following error:

----
An error has occurred while establishing a connection to the 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 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

For help, click:http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476
----

I'm certain the servers I'm trying to connect to allow remote connections so the fault must be on my side. Does anyone have any idea what the cause and solution might be?

Rydeman:

I'm certain the servers I'm trying to connect to allow remote connections so the fault must be on my side.

The default behaviour of a new sql install is to NOT allow remote connections until they are specifically enabled. Since you are dealing with a new install, i'd check the server settings to be sure:http://support.microsoft.com/kb/914277

|||

So for it to work both instances of sql server has to be configured to allow remote connections?

Because the reinstall is on the local client computer, the online servers are untouched.

|||yes may be it will work after re-install u have enable the TCP-IP connection in sql-server configuration manager

Cant connect remotely to SQL Server

I just reinstalled SQL Server and after reattaching my databases, I can't connect remotely. If I use "localhost" in my connection string it works fine, but I can't register my remote Enterprise Manager this way.

I have looked around and made sure that my SQL Server installation has the same name as my computer and I checked the networks settings for SQl Server and it says it is using port 1433 (as expected?). I can't ping port 1433, nor can I connect if I put :1433 in the connection string (is that normal?) I am no network expert so I am not sure of the expected behaviours. I am digging through the Internet for a solution (Microsoft Support is a bit pricy to be anything but a last resort for us), but I thought I would ask here in case someone has a suggestion.

Any help is appreciated.

SP4 was not installed properly, so SQL Server was not listening on port 1433. All fixed now!