Valid port ranges for SQL Server 2000

From: Glen Moffitt (gd.moffitt_at_verizon.net)
Date: 07/29/03 

Date: 29 Jul 2003 07:16:09 -0700

I'm looking at tweaking a few SQL 2000 servers, some with multiple
instances, to use non-standard TCP port assignments. Question is,
what's good and bad? Much of the MS documentation just alludes to the
fact you can (should) do this, but makes no specific recommendation as
to *what* port values can/should work. I did find a reference to the
iana official list of port numbers:

http://www.iana.org/assignments/port-numbers

So these are divided into three major sections: 1) 0-1023 ("well
known port numbers"), 2) 1024-49151 ("registered ports"- hmm, someone
called the "Cinderella Collaberation" has their own port?..), and 3)
49152-65535 ("Dynamic and/or Private").

Anyone had any good/bad luck with these port ranges? I would take it
avoid the registered and already assigned ones? Can sql and standard
client take a range up to 65535?

thks

Relevant Pages

  • Re: SQL DBA Client
    ... What is required depends on how you expose your SQL... ... measures you should consider are changing the port number ... you're using and using a User account with minimal ... Enterprise Manager accordingly (configuring the Client ...
    (microsoft.public.windows.server.sbs)
  • Re: Merge replication in SQL Server
    ... However, port 443 is for https, did you want your SQL ... Configuring an instance of SQL Server to use a static port ... you can script out replication jobs by right clicking on a publication ...
    (microsoft.public.sqlserver.replication)
  • Re: IIS, SQL 2000 & XPs Firewall
    ... Will anything change when I install SQL 2008 on the laptop? ... Queries to the Data Engine must go to the port that SQL Server is ... More info: How to: Configure a Windows Firewall for Database Engine Access ...
    (microsoft.public.sqlserver.connect)
  • 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)
  • SQL Adapter with Map blocks SQL Server?
    ... We have a receive port that executes a stored procedure via an SQL ... XmlReceive/Passthrough as receive/send pipeline and simply dump the XML ... if we specify inbound and outbound maps, ...
    (microsoft.public.biztalk.general)