We have a problem connecting to a server over a WAN and after some
experimenting found that Named Pipes would connect ok whereas TCP/IP fails
I am using cliconfg to set this on the workstation.. The error reported is
a network error. SQL is 2000 version
TheSQLGuru - 09 Jul 2008 22:57 GMT
Firewall issue?

Signature
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
> We have a problem connecting to a server over a WAN and after some
> experimenting found that Named Pipes would connect ok whereas TCP/IP fails
> I am using cliconfg to set this on the workstation.. The error reported
> is a network error. SQL is 2000 version
bluefrog@hotmail.com - 11 Jul 2008 19:50 GMT
Yes it was a firewall issue-our network guy had been 'improving'
performance!
> Firewall issue?
>
[quoted text clipped - 3 lines]
>> I am using cliconfg to set this on the workstation.. The error reported
>> is a network error. SQL is 2000 version
Linchi Shea - 09 Jul 2008 23:54 GMT
This may be too obvious, but is the server listening on TCP/IP?
Linchi
> We have a problem connecting to a server over a WAN and after some
> experimenting found that Named Pipes would connect ok whereas TCP/IP fails
> I am using cliconfg to set this on the workstation.. The error reported is
> a network error. SQL is 2000 version
>