SQL Server instance requirements
Connect SQL Server instances fulfilling the following requirements to Spotlight Cloud.
Spotlight Cloud Help
SQL Server instance connections
Spotlight Cloud monitors the SQL Server instances in your organization. Use this documentation to connect Spotlight Cloud to SQL Server.
Add/Edit SQL Server instance connection details
Supply SQL Server instance connection details to Spotlight Cloud.
Grant SQL Server instance 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 instance 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 availability of the SQL Server instance. If the SQL Server host is a Windows Server and is also monitored then check WMI operability.
SQL Server 2017 and Unix/Linux hosted connections
Spotlight Cloud provides partial support for monitoring SQL Server 2017 instances and SQL Server connections hosted on Unix/Linux.
SQL Server instance alarms
List the alarms that can be raised against the SQL Server instance connection.