Configure Database Mail

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' 

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

   

3. On the Select Configuration Task page, click Next

   

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

   

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

   Option	Value
   Profile name	Public DB Mail

   

6. 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. servgb_sqldb_0001@ROOT.local)

   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

   

7. On the New Profile page, click Next

   

8. 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

   

9. On the Configure System Parameters page, click Next

   

10. On the Complete the Wizard page, click Finish

    

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

    

Top

Copyright FineBuild Team © 2012 - 2019. License and Acknowledgements

Previous Backup Service Master Key	Top	Configure SQL Mail Next