Tuesday, February 14, 2012

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

No comments:

Post a Comment