SQL Server Connection Requirements
Connect SQL Server instances fulfilling the following requirements to Spotlight Cloud.
Spotlight Cloud Help
SQL Server Connections
Spotlight Cloud monitors the SQL Server connections in your organization. Use this documentation to connect Spotlight Cloud to SQL Server.
Manage SQL Server Connections
Supply SQL Server connection details to Spotlight Cloud.
Grant Account Permissions
In some environments it may not be feasible for Spotlight Cloud to connect to the SQL Server instance with an account that is a member of the sysadmin server role. The following instructions are provided for these environments.
Troubleshoot SQL Server Connection Failure
When Spotlight Cloud fails to connect to the SQL Server instance, check the SQL Server address and account authentication details have been entered correctly. Check the SQL Server host is in a domain. Check WMI operability. Check the availability of the SQL Server.