SQL Server Connections

Enter / Edit Connection Details using the Spotlight Configuration Tool Open the Configuration Tool. You will find the Configuration Tool on the desktop of the computer where Spotlight Cloud is installed. Double click the desktop icon. Sign in with your Quest account, and then from the Configuration panel, click Connections. This opens the Spotlight Connection Manager. To enter connection details either click Add new Connection or double click on the connection with details you want to edit.

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.

Script to grant permissions to TrustedUser Run the following SQL script (as sysadmin) to grant the required permissions to user TrustedUser. Note the comment lines at the end of the script and un-comment as appropriate for your environment. use master grant ALTER TRACE to TrustedUser grant VIEW SERVER STATE to TrustedUser grant VIEW ANY DEFINITION to TrustedUser USE [master] GO CREATE USER [TrustedUser] FOR LOGIN [TrustedUser] GO USE [msdb] GO CREATE USER [TrustedUser] FOR LOGIN [TrustedUser] GO grant VIEW DATABASE STATE to TrustedUser use msdb EXECUTE sp_addrolemember @rolename = 'SQLAgentReaderRole', @membername = 'TrustedUser' use msdb EXECUTE sp_addrolemember @rolename = 'TargetServersRole', @membername = 'TrustedUser' grant select on dbo.

Check the connection details using the Spotlight Configuration Tool Open the Configuration Tool. You will find the Configuration Tool on the desktop of the computer where Spotlight Cloud is installed. Double click the desktop icon. SQL Server address Check the address is a valid server name, server instance name or IP address. For a Microsoft Cluster Server (MSCS) use the virtual name of the cluster. Authentication The connection will fail if the account permissions are insufficient to allow Spotlight to collect the data it needs.