Create Database Mail Profile and Account Dialog Box (Master Data Services Configuration Manager)
Use the Create Database Mail Profile and Account dialog box to create a Database Mail profile and a Database Mail account for the Master Data Services database. This profile will be used to notify users and groups by e-mail when business rule validation fails.
Database Mail Profile and Account
A Database Mail profile is a collection of Database Mail accounts. A Database Mail account contains the information that SQL Server uses to send e-mail messages to an SMTP server. When you create the profile and account in Master Data Services Configuration Manager, the account is automatically added to the profile and that account information is used to send e-mails.
Note
You cannot use Master Data Services Configuration Manager to update existing Database Mail profiles or accounts, nor can you configure more than one account for a profile. To perform more advanced tasks with Database Mail, you can use SQL Server Management Studio or Transact-SQL scripts. For more information, see the Database Mail Configuration Objects section in SQL Server Books Online.
Control Name |
Description |
|---|---|
Profile name |
Type a name for the new Database Mail profile. This name must be unique among the Database Mail profiles configured for the Master Data Services database. After you create this profile, it is available and selected on the Database page in Master Data Services Configuration Manager. |
Account name |
Type a name for the new Database Mail account to associate with this profile. This name must be unique among the Database Mail accounts configured for the Master Data Services database. This account does not correspond to a SQL Server account nor to a Windows user account. |
Outgoing (SMTP) Mail Server
Control Name |
Description |
|---|---|
E-mail address |
Type the name of the e-mail address for the account. This is the e-mail address that e-mail is sent from, and it must be in the format e-mail_name@domain_name. An example e-mail address is sales@contoso.com. |
Display name |
Optional setting. Type the name to display on e-mail messages sent from this account. An example display name is Contoso Sales Group. |
Reply e-mail address |
Optional setting. Type the e-mail address to use for replies to e-mail messages sent from this account. An example reply e-mail address is admin@contoso.com. |
SMTP server |
Type the name or IP address of the SMTP server the account uses to send e-mail. An example SMTP server format is smtp.<company_name>.com. For help with this, consult your mail administrator. |
Port number |
Type the port number of the SMTP server for this account. The default SMTP port is 25. |
This server requires a secure connection (SSL) |
Encrypts communication using Secure Sockets Layer (SSL). |
SMTP Authentication
Database Mail can be sent by using the credentials of the SQL Server Database Engine, by using other credentials that you supply, or anonymously. As a best practice, if your e-mail server requires authentication, create a specific user account to use for Database Mail. This user account should have minimal permissions, and should not be used for any other purpose.
Control Name |
Description |
|---|---|
Windows Authentication using Database Engine service credentials |
Specify that Database Mail should use the credentials of the SQL Server SQL Server Database Engine Windows service account for authentication on the SMTP server. |
Basic authentication |
Specify that Database Mail should use a specific user name and password to authenticate on the SMTP server. This information is used only for authentication with the e-mail server, and the account need not correspond to a SQL Server user or user on the computer running SQL Server. |
User name |
Type the name of the user account that Database Mail uses to log on to the SMTP server. A user name is required if the SMTP server requires basic authentication. |
Password |
Type the password that Database Mail uses to log on to the SMTP server. A password is required if the SMTP server requires basic authentication. |
Confirm password |
Type the password again to confirm the password. |
Anonymous authentication |
Specify that the SMTP server does not require authentication. Database Mail will not use any credentials to authenticate on the SMTP server. |