Server not listening on 1433

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
.

Relevant Pages

  • RE: Printing from Win9x clients stops
    ... Open Server Management. ... then right-click the name of the computer running Windows Small Business ... >From the client computer: ... The Select Network Component Type ...
    (microsoft.public.windows.server.sbs)
  • RE: Printing from Win9x clients stops
    ... The printers with 9x drivers on the server appeared automatically in the ... > then right-click the name of the computer running Windows Small Business ... > From the client computer: ... The Select Network Component Type ...
    (microsoft.public.windows.server.sbs)
  • Re: Daily Server Report (Critical Errors, Event ID: 537)
    ... Does this issue happen on client workstation or server? ... Does your server and all clients' workstation work well now? ... issue in your Network? ...
    (microsoft.public.windows.server.sbs)
  • Re: Small business thinking about backing up data, having a server and 2-3 users - is SBS200
    ... is networked to the Master with a crossover network cable. ... Master on the Master PC and Client on the Slave pc. ... Since this machine is a server is should handle the requests ok ... Most real firewall appliances have HTTP and SMTP proxy services that allow ...
    (microsoft.public.windows.server.sbs)
  • RE: Private addresses on public network
    ... anybody accesses those computers from an external network," -- even when the ... JavaScript delivered to the client that causes the client to retrieve ... the attacker, the request results in another JavaScript response that tells ... Moving beyond a single server ...
    (Security-Basics)