How to enter / edit connection details
Use a Spotlight Client to enter / edit connection details.
From the Spotlight Client
- Click Configure | Connections.
- Double click Add new connection.
- Fill in the connection details.
Connection details
Address
The URL used to link to the SQL Azure database.
Authentication
Specify the authentication for Spotlight to use to connect to the SQL Azure database.
Select the SQL Server Authentication from the Authentication field. In the User field, enter a valid user name that enables Spotlight to connect to the SQL Azure database. In the Password field, enter a password to connect the specified user to the SQL Azure database.
Select the Microsoft Entra Password from the Authentication field and fill in the User and Password fields. Ensure the user is allocated as an admin user for SQL Azure database active directory.
Select the Microsoft Entra MFA from the Authentication field and fill User and Application ID fields. Ensure the user is allocated as an admin user for SQL Azure database active directory and Application ID is provided for SQL Azure database connection.
Select the Microsoft Entra Integrated from the Authentication field. User and Password fields are disabled for this authentication mode and will be using Dignostic Server credentials. Ensure the user is allocated as an admin user for SQL Azure database active directory and Spotlight Diagnostic Server is logged in using the same user credentials.
Database
The name of the SQL Azure database.
Connection Failure Properties
Set the connection timeout and the number of times Spotlight should attempt to connect to SQL Azure before raising the Connection Failure alarm.
Test the connection
On entering / modifying connection details in the Spotlight Client, click Test to test the connection.