none
Accessing sql server from behind isa 2000 RRS feed

  • Question

  • Hi

    My app am unable to access a remote sql server (hosted by our web host) from a sbs 2003 premium (with isa 2000). The app bombs with the 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)

     

    I have tried osql command and I get below results;

    C:\Documents and Settings\Administrator>osql -E -Stcp:mysqlserver.com
    [DBNETLIB]SQL Server does not exist or access denied.
    [DBNETLIB]ConnectionOpen (Connect()).

    Do I need to open any ports on ISA Server 2000? The sql server is accessible fine from a standalone pc that is not connected to sbs.

    Thanks

    Regards

    Friday, June 6, 2008 4:47 AM

Answers