Configure Database Mail - SQL-FineBuild/Common GitHub Wiki

Previous Backup Service Master Key Manual Configuration Configure SQL Mail Next

FineBuild can Configure Database Mail for use by SQL Server Agent.

The Database Mail functionality is used by the SQL Server Agent instance. It uses SMTP to send and receive mail, and avoids the reliability shortcomings experienced when using MAPI-based mail.

SQL Server must be running using a Domain service account for Database Mail to be configured.

FineBuild Configure Database Mail

The Database Mail configuration relates to Process Id 5BB and is controlled by the parameters below:

SQL Version Parameter FULL Build WORKSTATION Build CLIENT Build
SQL2019 /SetupDBMail: Yes Yes N/A
SQL2017 /SetupDBMail: Yes Yes N/A
SQL2016 /SetupDBMail: Yes Yes N/A
SQL2014 /SetupDBMail: Yes Yes N/A
SQL2012 /SetupDBMail: Yes Yes N/A
SQL2008R2 /SetupDBMail: Yes Yes N/A
SQL2008 /SetupDBMail: Yes Yes N/A
SQL2005 /SetupDBMail: Yes Yes N/A

In order to maintain compatibility with older versions of SQL FineBuild, the parameter ConfigDBMail can also be used.

FineBuild also uses the following parameters to help configure Database Mail:

Parameter Default Value Description
/Mailserver: see text Name of the Mail Server to be used. This will default to the nearest Exchange Server in the Domain if one can be found.
/DBMailProfile: Public DB Mail Database Mail profile name.

FineBuild will automatically:

  1. Enable the use of Database Mail
  2. Create a Default Public database mail profile
  3. Create a Database Mail account
  4. Link the account to the profile

Top

Manual Configure Database Mail

The following steps show what you would have to do for manual Database Mail configuration. FineBuild does all of this work for you automatically.

SQL Server must be running using a Domain service account for Database Mil to be configured.

  1. Use SQL Server Management Studio to run the following command to enable the use of Database Mail:
  SP_Configure 'Database Mail XPs', '1'

  1. Navigate to Management -> Database Mail, right-click and select Configure Database Mail

    ![SSMS Configure DB Mail](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/SQLConfiguration/InstanceConfiguration/ConfigureDatabaseMail/SSMS Config DB Mail.png)

  2. On the Select Configuration Task page, click Next

    ![Configuration Task](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/SQLConfiguration/InstanceConfiguration/ConfigureDatabaseMail/Config Task.png)

  3. If a message similar to the following appears, click Yes

    ![DB Mail Enable](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/SQLConfiguration/InstanceConfiguration/ConfigureDatabaseMail/DB Mail Enable.png)

  4. Set the following New Profile value then click on Add

    Option Value
    Profile name Public DB Mail

    ![New Profile](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/SQLConfiguration/InstanceConfiguration/ConfigureDatabaseMail/New Profile.png)

  5. Set the following New Database Mail Account values, then click OK

    Option Value
    Account Name SQL Alerts
    E-mail address service account email address
    Display name SQL Server instance name
    Server name SMTP or Exchange server name
    Windows authentication Selected

    Notes:

    a) The service account email address will always take the form of serviceaccount@dnsdomain (E.G. [email protected])

    b) The Exchange server name can be obtained from your Support Centre

    c) If an SMTP server is used, either Basic or Anonymous authentication must be used

    d) Site standards may require This server requires a secure connection (SSL) to be checked

    ![Mail Account](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/SQLConfiguration/InstanceConfiguration/ConfigureDatabaseMail/Mail Account.png)

  6. On the New Profile page, click Next

    ![Next](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/SQLConfiguration/InstanceConfiguration/ConfigureDatabaseMail/New Profile Next.png)

  7. On the Manage Profile Security page, clear the Show only existing public profiles field.

    Set the following Manage Profile Security values, and then click Next

    Option Value
    Public Checked
    Default Profile Yes

    ![Manage Profile](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/SQLConfiguration/InstanceConfiguration/ConfigureDatabaseMail/Manage Profile.png)

  8. On the Configure System Parameters page, click Next

    ![System Parameters](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/SQLConfiguration/InstanceConfiguration/ConfigureDatabaseMail/System Parameters.png)

  9. On the Complete the Wizard page, click Finish

    Complete

  10. On the Configuring page, all operations should show Success. Click Close to finish.

    Configuring

Top

Copyright FineBuild Team © 2012 - 2019. License and Acknowledgements

Previous Backup Service Master Key Top Configure SQL Mail Next