SQL TCP/IP Port

  • Hello Room,

    I need to change the sql server 2000 and 2005 TCP/IP port 1433 to something else.

    What is the best practice port range that I can use for SQL Server 2000 and 2005.?

    Thank you for your kind help.

    TJ

  • Potentially you could use any port over 1024 that isn't [likely to be] used by anything else. You may be better off using a port above 49152. See IANA for a list of registered ports already registered/in use:

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



    Scott Duncan

    MARCUS. Why dost thou laugh? It fits not with this hour.
    TITUS. Why, I have not another tear to shed;
    --Titus Andronicus, William Shakespeare


  • THank you for the help.

    Best regards,

    TJ

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply