How to configure SQL Server to listen on a specific port (Windows NT)

To configure SQL Server to listen on a specific port

  1. Use the Registry Editor to find the Registry key (Regedt32.exe is usually found in the SYSTEM32 directory under the Microsoft® Windows NT® root directory):

    HKEY_LOCAL_MACHINE
    \SOFTWARE
    \MICROSOFT
    \MSSQLSERVER
    \MSSQLSERVER
    \RPCNetlib


    Note This registry key is present only when you have installed the Multiprotocol network library and have enabled Multiprotocol encryption. Only system administrators can edit registry key values.


  2. After you have located the registry key, create a new value named RPCprotocols and assign it a value type of REG_MULTI_SZ.
  3. For the value, enter one or more of the following strings to control which protocols are used and the particular named pipe, TCP port, or SPX socket on which the server listens for connections.
Network connection Description
ncacn_ip_tcp[,port] Directs the server to listen for connections on TCP/IP. If port is specified, it is used as the number of the TCP/IP port to which the server listens for connections.

The TCP/IP port number 1433 has been registered specifically with the Internet Assigned Number Authority (IANA), and should usually be used for the TCP/IP port number to avoid conflicts with other statically or dynamically assigned port numbers.

Ncacn_np[,name] Directs the server to listen for connections using LAN Manager Named Pipes. If name is specified, it is used as the name of the named pipe to which the server listens for connections.
Ncacn_spx[,socket] Directs the server to listen for connections using SPX Sockets. If socket is specified, it is used as the number of the SPX socket to which the server listens for connections.

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.