Page History
...
The following documentation should also be reviewed: Verifying the Configuration configuration of SQL Server Portsports and SQL Server Locks.
Configuring a static port
...
- Start the Server Network Utility by doing one of the following:
- Click Start > Programs > Microsoft SQL Server > Server Network Utility, or
- Click Start > Run. In the Open box, type svrnetcn.exe, and then click OK.
- In the SQL Server Network Utility dialog box, click the General tab.
- In the Instance(s) on this server list, select your instance of SQL Server.
Info If the TCP/IP protocol is disabled, enable it by clicking TCP/IP in the Disabled Protocols list box, and then clicking Enable.
- In the Enabled Protocols list box, click TCP/IP, and then click Properties.
- In the Default port box, type a number for the static port, and then click OK.
Info 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.
- Click OK twice.
- Restart the instance of SQL Server.
- View the SQL Server error logs to verify whether or not the instance of SQL Server is currently using the static port.
...
For more information about these topis, see:
- Required Ports ports for the Uptime Infrastructure Monitor Monitoring Stationmonitoring 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?
- Adding a firewall rule to open port 9998 for Linux agent
- Changing the Windows agent port