SQL Server Performance

What is the reasoning behind altering the port number for a named instance and making it static

Discussion in 'Getting Started' started by lcerni, Aug 4, 2010.

  1. lcerni New Member

    We have a SQL Server 2005 default instance set up on a server. I was requested to install a named instance and to use a static port number. What is the benefit of changing the port number to be diferent and to be static? I have never done that before. I always took the defaults.
    lcerni, Aug 4, 2010
    #2

  2. satya Moderator

    SQL Server is a Winsock application that communicates over TCP/IP using the sockets network library. The SQL Server listens for incoming connections on a particular port; the default port for SQL Server is 1433. The port doesn't need to be 1433, but 1433 is the official Internet Assigned Number Authority (IANA) socket number for SQL Server. See this articl3e http://technet.microsoft.com/en-us/library/bb726981.aspx on how TCP/IP interacts.
    Further information read on this KBA http://support.microsoft.com/kb/823938
    satya, Aug 4, 2010
    #3

  3. lcerni New Member

    I have learned that they are changing the port number for the JAVA programmers.
    lcerni, Sep 27, 2010
    #4

  4. satya Moderator

    That is good to seperate the applications based on the ports.
    satya, Sep 30, 2010
    #5

Share This Page