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\Admini strator>osql -E -Stcp:mysqlserve r.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
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\Admini strator>osql -E -Stcp:mysqlserve r.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