The Notification tab of the Service Properties dialog allows you to send a notification to an email address when a group of subscriptions completes, encounters errors, or encounters errors or warnings. The SMTP mail server must be able to direct email to the user account specified in the “To” parameter and accept any value as the sender.
Complete the Email Properties to enable sending notifications from the SQDR Service to an email address. If you need to disable this feature clear one of the fields, such as the From field. The notification feature and the Test button are enabled only when all the fields have values.
Important: Restart the SQDR service after modifying the Email Properties.
Complete the following fields to enable the email notification feature. The SQDR Service automatically adds a Subject line to each email that identifies the severity of the notification: SQDR Information Notification, SQDR Warning Notification, or SQDR Error Notification.
To |
Specify a valid email address, in the form of name@domain.com, in the To field. The To address is the one that will receive the email notification. |
From |
The From field can contain any character string in the form of a valid email address. The text that you enter appears in the From field of the notification email. If one person will receive SQDR notifications from multiple computers, you can use the From field to identify the process and computer from which the notification is sent, such as SQDR_COMPUTERNAME@domain.com. If you are sending the notifications to another person you may want to enter your own email address in the From field, in the form of yourname@domain.com, to help identify the origin of the email and provide a valid address for return communications. |
SMTP Server |
Specify the Internet address of an SMTP server that provides outgoing email service. An Internet address can be an IPv4 address, an IPv6 address, or a DNS domain name. If you are using an SMTP server that requires authentication or specific encryption settings, set the notifyUserID, notifyPassword & notifyMailEncryption advanced settings. |
Port |
Specify the number of the port on which the SMTP server is listening for sendmail requests. The default port number is 25. |
Click the Test button to send a test email to the specified account, and click OK to save the service notification properties. If you want to discontinue sending notifications to email, clear one of the Email Properties fields and save the service properties again.
In the Message Types pane you select which type of messages you want to receive. You can choose one of the following message categories, with All being the most inclusive.
All |
Sends an email when a group of subscriptions completes successfully or encounters warnings or errors. For groups of subscriptions that perform incremental replication, notifications also are sent if there are errors polling the source, if the subscription is paused, and when incremental counters are reset. |
Warning and Errors |
Sends an email if a group of subscriptions encounters a warning or error. |
Errors Only |
Sends an email if a group of subscriptions encounters an error. |
To send email using Office365, use one of the following configurations:
To use Direct Send (typically used for printers, scanners, other devices, and applications):
SMTP server: your-domain.mail.protection.outlook.com
(the MX endpoint for your Office 365 tenant)
Port: 25
notifyMailEncryption: 2 (TLS only)
Advantages:
This method does not require authentication.
The From address can be any meaningful name as long as it is properly formatted e.g. sqdr@mydomain.com. It does not have to be a registered/licensed Office365 user.
Disadvantages:
You can't relay to an email address outside your domain.
Your IP address has to be white-listed, which adds complications when SQDR is running in the cloud (e.g. AWS or Azure).
Use SMTP client submission endpoint (this is typically used by email client applications like Outlook) to send email to an address outside your domain:
SMTP server: smtp.office365.com
Port: 587
notifyMailEncryption: 2 (TLS only)
You must configure authentication (notifyUserID and notifyPassword) - see Advanced Settings.
The value specified for notifyUserID must match NotifyFromAddress. This means using a registered/licensed Office365 user, and the NotifyFromAddress address may not be as descriptive as it could be otherwise, especially if you are using the same credentials for multiple SQDR servers.
When using this method, the Test Button will generate a misleading error message (which is still successfully delivered as an email); however, the desired messages from the service itself will be delivered without error.
Note that SMTP AUTH client submission is not compatible with Microsoft Security Defaults, but can be enabled per-mailbox.
Configure a Office 365 SMTP relay connector to authenticates your device or application with Office 365 using an IP address or a certificate.
The Office 365 administrator creates an SMTP relay connector in the Exchange admin center, specifying Your organization's email server in the From dropdown, and supplying your static IP address.
Configure SQDR as above for Direct Send:
SMTP server: your-domain.mail.protection.outlook.com
(the MX endpoint for your Office 365 tenant)
Port: 25
notifyMailEncryption: 2 (TLS only)
Advantages:
This method does not require authentication.
The From address can be any meaningful name as long as it is properly formatted e.g. sqdr@mydomain.com. It does not have to be a registered/licensed Office365 user.
You can relay to an email address outside your domain.
Disadvantages:
Your Office365 administrator must create the connector.
You must use a static IP address that belongs to your organization exclusively.
The connector could potentially be abused by other devices and computers within your network. For example, a compromised desktop computer within your network could use the connector to send spam to external addresses.
For detail, see the Microsoft documentation.