SQL Server Performance

Configure SQL Server Named Instance to use default port 1433

Discussion in 'SQL Server 2005 General DBA Questions' started by Trev256, Jun 16, 2008.

  1. Trev256 New Member

    Hi - SQL Server 2005 has been installed with a named instance (and no other instances). This is not using port 1433. Can this be changed to use port 1433? If so, how?
    NB. It appears that you can change the port used by sql server, but it is unclear in BOL whether you can chnage a port for a specific instance.
  2. satya Moderator

    I'm surprised to hear that BOL is not clear to provide such information, as the following is clearly stated within Index: ports [SQL Server], changing
    You can configure TCP/IP and VIA protocols to listen on a designated port. By default, the default instance of the Database Engine listens on TCP port 1433. Named instances of the Database Engine and SQL Server Compact Edition are configured for dynamic ports, which means they select an available port when the SQL Server service is started. The SQL Server Browser service helps clients identify the port when they connect.
    When configured for dynamic ports, the port used by SQL Server may change each time it is started. When connecting to SQL Server through a firewall, you must open the port used by SQL Server. Configure SQL Server to use a specific port, so you can configure the firewall to allow communication to the server. See also, /msdn.microsoft.com/mshelp" />How to: Configure a Server to Listen on a Specific TCP Port (SQL Server Configuration Manager).
    If it is a named instance, port 1434 needs to be unblocked for the client to discover which port it should connect on. If it is a default instance, then the port will be read from the client configuration. However, if your application is specifying the port in its connection string, then only that port will be used and the client configuration won't be used.
  3. Trev256 New Member

    Hi Thanks - I found the info - Also I changed the dynamic port number - Does it have to have the setting of zero '0' - entered as it appears to wrok without this being displayed?Thanks again.
  4. satya Moderator

    Yes 0 means it is set to dynamic.
  5. suniljk7 New Member

    Named Instance will take dynamic port by default, we can change this.
    In SQL Server Configuration Manager>SQL Server 2005 Network Configuration>Protocols for "instance name", then select TCP/IP, then take IP Address tab. Under IPAll or (IP1/IP2 which ever is ur IP)> TCP Dynamic Ports delete '0' and below TCP Port <your port>. Then restart sql server service from services.msc. Now it will work on your port. Also you can check whether your port is listening or not by using telnet to the port.
    Thanks
    John

Share This Page