SQL2000 Remote Connections (inside LAN)

fixitchris via SQLMonster.com

unread,

Nov 6, 2006, 3:08:19 PM11/6/06

to

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

fixitchris via SQLMonster.com

unread,

Nov 6, 2006, 4:45:28 PM11/6/06

to

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.

fixitchris via SQLMonster.com

unread,

Nov 6, 2006, 4:50:21 PM11/6/06

to

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

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

fixitchris via SQLMonster.com

unread,

Nov 6, 2006, 4:57:52 PM11/6/06

to

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

fixitchris via SQLMonster.com

unread,

Nov 6, 2006, 5:03:45 PM11/6/06

to

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

fixitchris via SQLMonster.com

unread,

Nov 6, 2006, 5:12:00 PM11/6/06

to

RESOLVED:::::

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

arrrrhhgghghghghhghghg!