Spotlight can monitor SQL Server instances of the following versions, editions Enterprise, Standard and Express:
- SQL Server 2017 (64-bit)
- SQL Server 2016 (64-bit)
- SQL Server 2014 (32-bit and 64-bit)
- SQL Server 2012 (32-bit and 64-bit)
- SQL Server 2008 R2 (32-bit and 64-bit)
- SQL Server 2008 (32-bit and 64-bit)
- SQL Server 2005 (32-bit and 64-bit)
Spotlight cannot monitor earlier versions of SQL Server (SQL Server 2000 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.
If the SQL Server instance is hosted on a Windows server and UDP port 1434 is closed then the port number must be included in the address used to connect Spotlight to the SQL Server instance.
Spotlight can only connect to Windows servers in a domain. Spotlight cannot connect to databases hosted on Windows servers in a workgroup.