How To Setup Email Using Microsoft SQL Server

This topic discusses setting up Microsoft SQL Server to act as an Email Server.

You must have SQL Server 2019 Standard edition or higher installed.

Email Setup

Most email providers are now requiring Two-Factor authentication to secure email accounts. In order to send emails, this needs to be bypassed.

If your email has multi-factor authentication enabled, sign in and setup an Application Password. Please refer to your email provider's documentation.

SQL Server Setup

The below script needs to be run in SQL Server Management Studio.

1. Sign in to Management Studio with administrative rights.
2. Open a new query window.
3. Copy and paste the above code into the query window.
4. Execute the query.

Operator Configuration

There are 2 parts to setting up an Operator:

1. Enabling SQL email on the Operator Email tab.
2. Inputting the Operator's email settings.

Operator Email Tab

1. Sign into Collect!.
2. Navigate to System -> Rights -> Active Operators.
3. Find the applicable operators to enable emailing.
4. Open the operator profile and navigate to the Email tab.
5. Select SQL in the Email Type field.
6. Click OK and repeat for any other operators.

Leave the Email Server IP field blank as it has no effect on the SQL email type.

Operator Email Configuration

1. Sign into Collect!.
2. Navigate to the Work in Progress.
3. If you are setting up the settings for another Operator, select the Operator from the Load Contacts for Operator field.
4. Click the Configure Email button.
5. Fill in the email settings.
   • Email Server
   • Email Server Port
   • Is SSL encryption needed to communicate with the email server.
   • Username
   • Password

Delete Email Configuration

Deleting email configuration is done automatically when you reconfigure and Operator. If you want to delete the configuration without recreating any, follow the steps below.

1. Sign into Collect!.
2. Navigate to the Work in Progress.
3. If you are deleting the settings for another Operator, select the Operator from the Load Contacts for Operator field.
4. Click the Delete Email Settings button.

Troubleshooting

.NET Framework 4.5.2 or higher must be installed.

This only works with SQL Server Standard or higher. Emailing is not avaiable in SQL Express.

Check your email provider to see if you need an Application Password.

Check your email provider to see if SSL encryption is needed.