SQL Server Connections - Spotlight Cloud Help
Spotlight Cloud Help

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.