Chat now with support
Chat with Support

Spotlight on SQL Server Enterprise 11.7 - Release Notes

Network ports

A Spotlight on SQL Server deployment consists of many components that may be spread over a wide network. Spotlight's ability to function, to collect and display data, may depend on account permissions granted over the network and specific open network ports.

Table 67: Network ports on the Spotlight Diagnostic Server

Network port Description

TCP 3843

This port is used by the Spotlight client to communicate with the Spotlight Diagnostic Server. This port must be open for incoming connections on the Spotlight Diagnostic Server host.

TCP 3166

This port is used by the Spotlight Diagnostic Server to communicate with the Spotlight OOP Collector process on the same host. No external connections are required on this port.

TCP 443

This port is used by the Spotlight Diagnostic Server to communicate with Spotlight Cloud. This port must be open for outgoing connections on the Spotlight Diagnostic Server host when Configure uploading to Spotlight Cloud is enabled.

TCP 40403

This port is used by the Spotlight client to communicate with the Spotlight Diagnostic Server. This port must be open for incoming connections on the Spotlight Diagnostic Server host.

 

TIP: The Spotlight Diagnostic Server uses WMI queries to retrieve performance counter information from monitored Windows Server and hosts of database connections. Verify TCP port 135 is open on monitored Windows server and hosts of database connections.

SQL Server uses UDP 1434 to locate the SQL Server instance port number. If UDP 1434 is closed then the SQL Server instance port number must be included in the connection string used to connect Spotlight to the SQL Server instance.

Checks to verify ports are open

  • Verify a firewall is not blocking port traffic.
  • Verify no other service is using the port.
  • Verify the port is not configured as an ephemeral port. This issue may arise if you have configured your Windows ports beyond Windows Factory settings or your Windows host is Windows 2008 with Exchange Server 2007. For more information on ephemeral (dynamic) ports, see https://support.microsoft.com/en-us/kb/929851
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating