sql server msde: 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?


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 *:*

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-msde/200611/1

here is some additional info from the logs:

GATEWAY (default instance)
SuperSocket Info: Bind failed on TCP port 1433

GATEWAY\MSFW instance
SQL server listening on 200.200.200.10: 1433.
SQL server listening on 172.16.0.3: 1433.
SQL server listening on 172.16.0.4: 1433.
SQL server listening on 127.0.0.1: 1433.
SQL server listening on TCP, Shared Memory.

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-msde/200611/1

it doesn't look like its listening on the LAN side (172.16.0.3 or .4) ??????
!!!!!!


C:\Documents and Settings\>netstat -an

Active Connections

Proto Local Address Foreign Address State

TCP 0.0.0.0:135 0.0.0.0:0 LISTENING
TCP 0.0.0.0:445 0.0.0.0:0 LISTENING

TCP 0.0.0.0:1433 0.0.0.0:0 LISTENING

TCP 200.200.200.10:1433 200.200.200.10:44832 ESTABLISHED
TCP 200.200.200.10:1433 200.200.200.10:44892 ESTABLISHED

UDP 0.0.0.0:161 *:*
UDP 0.0.0.0:445 *:*
UDP 0.0.0.0:500 *:*
UDP 0.0.0.0:1025 *:*
UDP 0.0.0.0:1026 *:*
UDP 0.0.0.0:1027 *:*
UDP 0.0.0.0:1434 *:*
UDP 0.0.0.0:1528 *:*
UDP 0.0.0.0:1533 *:*
UDP 0.0.0.0:3456 *:*
UDP 0.0.0.0:4500 *:*
UDP 0.0.0.0:7060 *:*
UDP 0.0.0.0:31511 *:*
UDP 0.0.0.0:31512 *:*
UDP 0.0.0.0:31513 *:*
UDP 0.0.0.0:31553 *:*
UDP 0.0.0.0:54919 *:*
UDP 127.0.0.1:123 *:*
UDP 127.0.0.1:1028 *:*
UDP 127.0.0.1:1063 *:*
UDP 127.0.0.1:1067 *:*
UDP 127.0.0.1:1094 *:*
UDP 127.0.0.1:1135 *:*
UDP 127.0.0.1:1303 *:*
UDP 127.0.0.1:1310 *:*
UDP 127.0.0.1:1568 *:*
UDP 127.0.0.1:3456 *:*
UDP 127.0.0.1:40850 *:*
UDP 127.0.0.1:44631 *:*
UDP 127.0.0.1:53614 *:*
UDP 172.16.0.3:123 *:*
UDP 172.16.0.3:137 *:*
UDP 172.16.0.3:138 *:*
UDP 172.16.0.3:1745 *:*
UDP 172.16.0.4:123 *:*
UDP 172.16.0.4:1745 *:*
UDP 200.200.200.10:123 *:*
UDP 200.200.200.10:137 *:*
UDP 200.200.200.10:138 *:*
UDP 200.200.200.10:44642 *:*
UDP 200.200.200.10:54758 *:*
UDP 200.200.200.10:54799 *:*
UDP 200.200.200.10:54805 *:*
UDP 200.200.200.10:54807 *:*
UDP 200.200.200.10:54832 *:*
UDP 200.200.200.10:54834 *:*
UDP 200.200.200.10:54840 *:*
UDP 200.200.200.10:54842 *:*
UDP 200.200.200.10:54844 *:*
UDP 200.200.200.10:54846 *:*
UDP 200.200.200.10:54853 *:*
UDP 200.200.200.10:54865 *:*

--
Message posted via http://www.sqlmonster.com

well my bad... i guess it is listening... so my only thought is that ISA
SERVER is blocking that port!



C:\temp>portqry -n 172.16.0.3 -p tcp -o 1433

Querying target system called:

172.16.0.3

Attempting to resolve IP address to a name...


IP address resolved to Gateway.xxx.xxx.com

querying...

TCP port 1433 (ms-sql-s service): LISTENING

C:\temp>portqry -n 172.16.0.4 -p tcp -o 1433

Querying target system called:

172.16.0.4

Attempting to resolve IP address to a name...


IP address resolved to Gateway.xxx.xxx.com

querying...

TCP port 1433 (ms-sql-s service): LISTENING

C:\temp>portqry -n 200.200.200.10 -p tcp -o 1433

Querying target system called:

200.200.200.10

Attempting to resolve IP address to a name...


IP address resolved to Gateway.xxx.xxx.com

querying...

TCP port 1433 (ms-sql-s service): LISTENING

C:\temp>portqry -n localhost -p tcp -o 1433

Querying target system called:

localhost

Attempting to resolve name to IP address...


Name resolved to 127.0.0.1

querying...

TCP port 1433 (ms-sql-s service): LISTENING

--
Message posted via http://www.sqlmonster.com

Here are some ISA Logs... It's getting warmer

GATEWAY 2006-11-06 21:42:23 TCP 172.16.0.143:4197 172.16.0.3:1433 - Internal
Local Host Denied 0x800733f5 User Full Access Microsoft SQL (TCP) N 0 0 0 0 -
- - - - - - - 22 11593 - - -

GATEWAY 2006-11-06 21:57:32 UDP 172.16.0.156:1477 255.255.255.255:1434 172.16.
0.156 Internal Local Host Denied 0xc004000d - Microsoft SQL (UDP) N 0 0 0 0 -
- - - - - - - 0 0 - - -

--
Message posted via http://www.sqlmonster.com

RESOLVED:::::

Create a ISA rule to handle SQL TCP/UDP Traffic on internal network.

arrrrhhgghghghghhghghg!

--
Message posted via http://www.sqlmonster.com