Hi All,

Very strange problem here! Installed SQL 2000 on my Windows Server 2003 with
SP1. All went well. Got my DB working and clients connecting fine.

Went to connect a box in the DMZ via ODBC using TCP/IP on 1433 and it failed
to connect. Tried another box on the LAN and that wouldn't connect. Had a
look on the server and it seems that the server isn't listening on 1433
netstat -a

I've checked the Network properties, client network and server network in
SQL and all is set as I would expect it. Nothing else is listening on those
ports. I can connect fine by named pipes but the DB vendor would prefer me to
use TCP/IP.

Has anyone got any ideas? The SQL is SP3. It's a Compaq server that was
rebuilt from scratch only a few days ago.

If a client connects using dynamic ports what would i see when i do a
netstat -a or -b or -an ?

Many thanks,

Greg