Re: Server not listening on 1433

Hi Greg,

As you doubt, sql server may be listening in a different port. Check SQL
Server error log. SQL Server records in SQL Server error log, to which port
it is listening to...

Regards
Shri.DBA

"Greg New" <Greg New@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EBEC2E41-F72E-43CD-BCD2-28B8E7284128@xxxxxxxxxxxxxxxx
> 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: pen-test on a windows 2003 server box whit MS-SQL and Terminal Services
    ... laptop/pen-test system in as a Man-in-the-Middle between the SQL server ... > MS-SQL and Terminal Services ... > Have you done UDP port scans? ... obtaining the SQL version; since the OS is Win3k the SQL ...
    (Pen-Test)
  • Re: client cant connect when instance on one particular node
    ... Best practice is to specify a specific port and then code the client to ... SQL 2000 SP4 for SQL version. ... Then server guys evicted ... cluster configuration. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Connecting to an instance in a cluster
    ... "Geoff N. Hiten" wrote: ... you cannot reuse port numbers. ... Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: RealVNC
    ... Default listening port for RealVNC server that runs on the machine on which ... Then there is default Java listening port on port 5800 on the client machine ...
    (microsoft.public.windows.server.sbs)
  • Re: Remote ODBC connection to SQL Server 2005 Exp.
    ... Try scanning your Win2K server from the Internet to see if the port 1433 is ... I am using Access 2000 as the front end with SQL 2005 Exp. ... There is a Netgear RP 114 router for the office network. ...
    (microsoft.public.access.externaldata)
Loading