Documentation forSQL Sentry

SMTP Settings

Configure SMTP Settings in SQL Sentry

To configure SMTP settings in SQL Sentry, open the Navigator pane ( View > Navigator), and then select the Global Settings node (Configuration > Global Settings) to open SQL SentryMonitoring Service Settings. The Alerting tab displays by default.

SQL Sentry select Global Settings in the Navigator

In the Alerting tab, use the drop-down SMTP Server box to select an existing SMTP server to open the Select an SMTP Server dialog box, and configure a new SMTP server.

SQL Sentry Monitoring Service Settings Alerting tab

Note:  If using localhost, keep in mind this is the local SMTP server on the machine where the monitoring service is installed because it's responsible for sending all notifications. The SQL Sentry client doesn't send any notifications.

Note:  Contact your network administrator to ensure that the IP address of the monitoring service computer has been granted both Connect and Relay permissions for the specified SMTP server.

Add a new SMTP Server with basic authentication

  1. From the Alerting tab, select ... to open the Select an SMTP Server dialog box.

    SQL Sentry Monitoring Service Settings Alerting tab

  2. Select New to open the SMTP Server Editor dialog box.

  3. Enter the IP address or the domain name of the SMTP Server in the SMTP Server box. Enter the email that you want to send notifications in the From Address box. Optional: click to enable SSL and enter a custom port.

  4. Click the SMTP Authentication tab. Basic (authentication) is selected by default. Enter your Username and Password.

  5. Click Test to open the Send SMTP Test Email box, and then enter an email in the slot provided. Select Send to send the test email to the desired address.

  6. Select Okto save your SMTP settings.

Important:  For the most accurate SMTP test, use the SQL Sentry client installed on the server computer to send the test message. If you use a SQL Sentry client on a different computer, such as your local workstation, the results may differ. For example, your SMTP server may allow relay from your workstation but not from the SQL Sentry Server computer, in which case the test from your workstation would succeed; but the SQL Sentry Server would be unable to deliver notifications.

Note:  Configure multiple SMTP Servers in an SMTP Server group to use SQL Sentry's failover capabilities. For more information about configuring an SMTP Server group, and the SMTP Server group failover process, see the Monitoring Service SMTP Configuration article.

Add a new SMTP server with OAuth2 authentication

The Exchange Online tenant that you use for SMTP OAuth2 connections in SQL Sentry must have Mail.Read.Write and SMTP.SendAsApp API permissions enabled. For information about registering an app in Microsoft Exchange Online, see the Microsoft documentation.

  1. From the Alerting tab, select ... to open the Select an SMTP Server dialog box.

  2. Select New to open the SMTP Server Editor dialog box.


  3. Enter the IP address or the domain name of the SMTP Server in the SMTP Server box. Enter the email that you want to send notifications in the From Address box.

  4. Click the SMTP Authentication tab. Click Microsoft Exchange Online. Enter the following information to configure your SMTP OAuth2 connection.

    1. Username and Client Secret (access token) from your Microsoft Exchange Online app registration.

      The User is defined in Exchange and should match the From address you entered above. The Client Secret is created in exchange and will expire based on the date you have set.

    2. Enter the Tenant ID.

      The Tenant ID is found in Exchange Online through your app registration.

    3. Enter the Application ID.

      The Application ID is found in Exchange Online through your app registration.

    4. Enter the Object ID.

      The Object ID is found in Exchange Online through your app registration.

  5. Click Test to open the Send SMTP Test Email box, and then enter an email in the slot provided. Select Send to send the test email to the desired address.

  6. Select Okto save the SMTP OAuth2 settings.

Take note of the expiration date for your OAuth2 connection. Your connection credentials will expire on the expiration date, and beyond that date the SMTP OAuth2 connection will be unable to send alerts. You must create a new client secret through Exchange Online and update your credentials in SQL Sentry.