Check your Azure SQL Managed Instance fulfills the requirements of Spotlight Cloud.

Connection details

Open this dialog in the Spotlight Cloud Diagnostic Server application. Show me how to open the connection details screen in the Spotlight Cloud Diagnostic Server application.

Scroll down this help page for information specific to SQL Managed Instance connections.

Connection details

Azure SQL Managed Instance address

Specify the fully qualified server name used to link to the SQL Managed Instance.

If aliases are used then an incorrect alias on the client machine can cause connections to fail. Check the alias name of the instance.

Authentication

Select Azure Active Directory or SQL authentication to authenticate access to the Azure SQL Managed Instance.

Fill in the database User and Password fields. Ensure the database user has sufficient account permissions to retrieve performance data from the Azure SQL Managed Instance. Typically the account will be a member of the sysadmin server role. It could be a SQL Server login. If this is not feasible in your environment, see How to grant SQL Server account permissions to a trusted user.

The connection will fail if the account permissions are insufficient to allow Spotlight Cloud to collect the data it needs.

Where Azure Active Directory is selected, the User must be of the form of a valid email address.

Advanced options

Connection failure properties

Set the connection timeout and the number of times Spotlight should attempt to connect to the SQL Managed Instance before raising the connection failure alarm.

If the number of times Spotlight should attempt to connect to the SQL Managed Instance before raising an alarm is greater than 9 then type that number into the given field.

Alarms template: template

Select the alarms configuration template to apply to this connection or select Factory Settings Template to apply the factory settings shipped with Spotlight Cloud. Select from any of the Azure SQL Managed Instance configuration templates that you have created through configure alarms.

The alarms template option is applicable only when creating a new Azure SQL Managed Instance connection. To apply a template to an existing SQL Managed Instance connection, see configuration templates.

Testing the connection

When you add a new SQL Managed Instance connection or edit the details of an existing connection, Spotlight Cloud tests its ability to connect.

Connection failure

If Spotlight Cloud fails to connect to the SQL Managed Instance then you may want to return to the connection details dialog to ensure the details you have entered are correct. You may want to troubleshoot SQL Managed Instance connection failure.

Saving a failed connection

Spotlight Cloud does allow you to save the connection details to a SQL Managed Instance that it has failed to connect to. If you do save the connection and Spotlight Cloud cannot connect to it then Spotlight Cloud will raise a connection failure alarm. Spotlight Cloud will re-try to connect every 30 seconds until successful. This could be a problem if associated services lock you out after a limited number of failed attempts. To clear the connection failure alarm, wait until Spotlight Cloud successfully connects (when Spotlight Cloud shows collected data). Then acknowledge the alarm.

There are things you can do to change Spotlight Cloud default behavior. You may want Spotlight Cloud to wait for a future occasion to monitor the connection rather than monitoring it right away. The simplest way to do that is to disable the connection. Spotlight Cloud will stop monitoring it. Spotlight Cloud will monitor the connection again when you enable it. See enable/disable.

Note that Spotlight Cloud automatically disables all connections added above your subscription quota.

Other features you may want to use if you save a failed connection are planned outage where you can delay monitoring of the connection till a specified time. You can create an alarm action rule to notify changes in status for an enabled connection.