Date: Fri, 29 Mar 2024 00:20:14 +0000 (UTC) Message-ID: <499093028.5559.1711671614311@ip-10-0-1-161.ec2.internal> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_5558_765109293.1711671614308" ------=_Part_5558_765109293.1711671614308 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
Cont= ents
You can configure an instance of SQL Server to use either static or dyna= mic ports.
The following documentation should also be reviewed: Verifying the Config= uration of SQL Server Ports and SQL Server Locks
To configure an instance of SQL Server to use a static port:
The SQL Server Network Utility dialog box appears.
In the Instance(s) on this server list, select your instance of SQL = Server.
Note
If TCP/IP protocol is disabled, enable it by clicking TCP/IP in the = Disabled Protocols list box, and then clicking Enable.
The static port that you specify must not be the same as the dynam= ic port on which your instance of SQL Server is currently listening. For ex= ample, if your instance of SQL Server is currently listening on dynamic TCP= /IP port 1400, type 1500 for the new static port.
Note
To configure your instance of SQL Server to use a dynamic port:
In the Instance(s) on this server list, select your instance of SQL = Server
Note
If TCP/IP protocol is disabled, enable it by clicking TCP/IP in the Disa= bled Protocols list box, and then clicking Enable.
If you have a clustered instanc= e 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 cl= uster nodes retain the old values. When you move the SQL Server group to th= e corresponding cluster node, and then bring SQL Server online on the clust= er node, the registry values on the cluster nodes will reflect the updated = values.
Other Port related articles:
Required Ports for the Uptime Infrastructur= e Monitor Monitoring Station
What ports n= eed to be open to add an ESX or vCenter system to Uptime Infrastructure Mon= itor?
What ports are required for WMI agentless monitoring
Add firewall rule to open port 9998 for Linux agent
Changing= the Windows Agent Port