Re: EM connects to server without knowing port

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: DWalker (None)
Date: 02/20/05 

Date: Sat, 19 Feb 2005 22:03:16 -0800

AND, the TCP port number given in the Client Network Utility seems a little
odd now that I think about it. You can specify *A* default port. Suppose
I connect to SQL servers on several machines, each with its SQL server
listening on a specific, different port. There's no way to pre-specify the
TCP data port for a given IP address?

I suppose that's why SQL servers listen on UDP port 1434, so they can reply
with their data port number. Seems like an odd design. The client should
be made to specify the port number if I have changed it on the server.

David

Relevant Pages

  • Wingate Replacement
    ... functionality of wingate to allow developers access to ... User connects to port 555 on wingate server which maps ... All access to these sql servers goes through this one ...
    (Focus-Microsoft)
  • Re: Connection providers vs
    ... I believe oSQL like most tools rely on the SQL Browser service to identify SQL Servers. ... It does this by communicating with port 1434 which is the default browser port and it will respond with the ports of any running instances on that particular server. ... I believe SQL Recon does a combination of both using the browser service and pinging particular ports looking for SQL Server to respond. ...
    (microsoft.public.sqlserver.connect)
  • Re: Accessing SQL 2K from SQL 7
    ... The SQL Client Network Utility creates aliases for SQL clients (including ... SQL servers accessing other SQL servers). ... and you can specify a port number. ... your server to determine the port number the named instance is listening on. ...
    (microsoft.public.sqlserver.security)
  • Two different ports?
    ... I connect to two different SQL servers on a regular basis. ... the SQL servers I connect using the default port 1433, ... By changing the port in ODBC Data Source Administrator, ... whenever I change the port for one of the System DSNs the other one ...
    (microsoft.public.sqlserver.setup)
  • Re: TCP/IP Socket number on a A/A SQL2000/Server2003 Cluster
    ... means "choose random unoccupied port at service startup". ... this can be a problem since they need a port number hard-coded ... Clustered SQL Servers typically look like named instances which do not use ...
    (microsoft.public.sqlserver.clustering)