To configure SQL Server to listen on a specific port
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.
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. |