Hello,

I am having trouble connecting remotely to a SQL2000 engine. It is located on the "gateway" PC where I have set up ISA Server. I am logging my proxy and firewall stuff to the local SQL2000 server with no problem. I have two instances of SQL: 'gateway' and 'gateway\msfw'. I have pipes and TCP set up for both instances and the agents have no problem running. I can connect locally just fine but not over the network... I only have the 2005 studio manager and OSQL.exe... I do not have sql2000 enterprise manager.

FYI, the pc has 2 NICs... 200.200.200.10 is the external and 172.16.0.3 is the internal. Below is an excerpt from Sysinternals TCPView

Any ideas?
Code:
sqlagent.EXE:4880	TCP	200.200.200.10:44832	200.200.200.10:1433	ESTABLISHED	
sqlagent.EXE:4880	TCP	200.200.200.10:44892	200.200.200.10:1433	ESTABLISHED	
sqlservr.exe:4680	TCP	0.0.0.0:1433	0.0.0.0:0	LISTENING	
sqlservr.exe:4680	TCP	200.200.200.10:1433	200.200.200.10:44892	ESTABLISHED	
sqlservr.exe:4680	TCP	200.200.200.10:1433	200.200.200.10:44832	ESTABLISHED	
sqlservr.exe:4680	UDP	0.0.0.0:1434	*:*