Can't access remote Sql Server from my web app

[David Thielen]

Hi;

My web application is trying to access Sql Server 2000 on a different box.
This works fine if they are on the same box. But on a different box I get:

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)

Any ideas?

--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com

[David Thielen]

Found it - wrong server name. Very weird error message for trying to open Sql
Server where a system with that name exists, but SqlServer on the box is not
running.

--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com

"David Thielen" wrote:

Hi;

My web application is trying to access Sql Server 2000 on a different box.
This works fine if they are on the same box. But on a different box I get:

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)

Any ideas?

--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com