Can't access remote Sql Server from my web app

Discussion in 'ASP .Net' started by =?Utf-8?B?RGF2aWQgVGhpZWxlbg==?=, May 31, 2006.

  1. 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
    =?Utf-8?B?RGF2aWQgVGhpZWxlbg==?=, May 31, 2006
    #1
    1. Advertising

  2. 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
    >
    =?Utf-8?B?RGF2aWQgVGhpZWxlbg==?=, May 31, 2006
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.

Share This Page