You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Contents


Overview
Configuring a Static Port
Configuring a Dynamic Port


Overview

You can configure an instance of SQL Server to use either static or dynamic ports.
The following documentation should also be reviewed: Verifying the Configuration of SQL Server Ports and SQL Server Locks

Configuring a Static Port

To configure an instance of SQL Server to use a static port:

  1. Start the Server Network Utility by doing one of the following:

Click Start > Programs > Microsoft SQL Server > Server Network Utility. Click Start > Run. In the Open box, type svrnetcn.exe, and then click OK.
The SQL Server Network Utility dialog box appears.

  1. In the SQL Server Network Utility dialog box, click the General tab.
  2. In the Instance(s) on this server list, select your instance of SQL Server.

Note
If the TCP/IP protocol is disabled, enable it by clicking TCP/IP in the Disabled Protocols list box, and then clicking Enable.

  1. In the Enabled Protocols list box, click TCP/IP, and then click Properties.

If TCP/IP protocol is disabled, enable it by clicking TCP/IP in the Disabled Protocols list box, and then clicking Enable.

  1. In the Default port box, type a number for the static port and then click OK.

The static port that you specify must not be the same as the dynamic port on which your instance of SQL Server is currently listening. For example, if your instance of SQL Server is currently listening on dynamic TCP/IP port 1400, type 1500 for the new static port.
Note
The static port that you specify must not be the same as the dynamic port on which your instance of SQL Server is currently listening. For example, if your instance of SQL Server is currently listening on dynamic TCP/IP port 1400, type 1500 for the new static port.

  1. Click OK twice.
  2. Restart the instance of SQL Server.
  3. View the SQL Server error logs to verify whether or not the instance of SQL Server is currently using the static port.


Configuring a Dynamic Port

To configure your instance of SQL Server to use a dynamic port:

  1. Start the Server Network Utility by doing one of the following:

Click Start > Programs > Microsoft SQL Server > Server Network Utility. Click Start > Run. In the Open box, type svrnetcn.exe, and then click OK.

  1. In the SQL Server Network Utility dialog box, click the General tab.
  2. In the Instance(s) on this server list, select your instance of SQL Server

Note
If the TCP/IP protocol is disabled, enable it by clicking TCP/IP in the Disabled Protocols list box, and then clicking Enable.

  1. In the Enabled Protocols list box, click TCP/IP, then click Properties.

If TCP/IP protocol is disabled, enable it by clicking TCP/IP in the Disabled Protocols list box, and then clicking Enable.

  1. Type 0 in the Default port box, and then click OK.
  2. Click OK twice.
  3. Restart the instance of SQL Server.
  4. View the SQL Server error logs to verify whether the instance of SQL Server is currently using the dynamic port.

If you have a clustered instance of SQL Server, and you follow the specified steps on a cluster node, you may notice that the TCPDynamicPorts and TCPPort registry values on other cluster nodes retain the old values. When you move the SQL Server group to the corresponding cluster node, and then bring SQL Server online on the cluster node, the registry values on the cluster nodes will reflect the updated values.
Other Port related articles:
Required Ports for the Uptime Infrastructure Monitor Monitoring Station
What ports need to be open to add an ESX or vCenter system to Uptime Infrastructure Monitor? What ports are required for WMI agentless monitoring
Add firewall rule to open port 9998 for Linux agent Changing the Windows Agent Port

  • No labels