Table 59: Spotlight on SQL Server is able to monitor the following connections
Spotlight can monitor SQL Server instances of the following versions:
Spotlight on SQL Server also supports MSDE (2000), SQL Express (2005) and SQL Server 2008 Express Edition. Note that use of these versions to host playback or Spotlight Statistics Repository databases is not supported.
Spotlight continues to monitor SQL Server 2000 instances Service Pack 3 or later, however no further support (fixes) will be provided.
Spotlight cannot monitor earlier versions of SQL Server (version 7.x and earlier).
Spotlight supports all SQL Server sort orders, including case-sensitive and binary sort orders. Spotlight cannot monitor SQL Server instances where the instance name contains non-US ASCII characters.
On each monitored instance Spotlight requires the network setting "File and Print Sharing" to be enabled.
UDP port 1434 should be open. If UDP port 1434 is closed then the port number must be included in the address used to connect Spotlight to the SQL Server instance.
|Database Cloud Service||Spotlight can be used to monitor SQL Azure.|
Spotlight can monitor the following operating systems:
Spotlight requires the network setting "File and Print Sharing" to be enabled and any firewall configured to open TCP port 135.
Spotlight can monitor virtual environments and virtual guest machines in a virtual environment. The following is supported:
The username used to connect to the virtual guest machine must have at least a read-only role.
Ensure any firewall is configured to open TCP port 135.