| title | Create Database Mail Profile and Account Dialog Box (Master Data Services Configuration Manager) | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 06/13/2017 | |
| ms.prod | sql-server-2014 | |
| ms.reviewer | ||
| ms.technology | master-data-services | |
| ms.topic | conceptual | |
| f1_keywords |
|
|
| ms.assetid | b93ea3d4-9f22-490e-8e26-d766b454aed6 | |
| author | lrtoyou1223 | |
| ms.author | lle | |
| manager | craigg |
Use the Create Database Mail Profile and Account dialog box to create a Database Mail profile and a Database Mail account for the [!INCLUDEssMDSshort] database. This profile will be used to notify users and groups by email when business rule validation fails.
A Database Mail profile is a collection of Database Mail accounts. A Database Mail account contains the information that [!INCLUDEssNoVersion] uses to send email messages to an SMTP server. When you create the profile and account in [!INCLUDEssMDScfgmgr], the account is automatically added to the profile and that account information is used to send emails.
Note
You cannot use [!INCLUDEssMDScfgmgr] 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 [!INCLUDEssManStudioFull] 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 [!INCLUDEssMDSshort] database. After you create this profile, it is available and selected on the Database page in [!INCLUDEssMDScfgmgr]. |
| 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 [!INCLUDEssMDSshort] database. This account does not correspond to a [!INCLUDEssNoVersion] account nor to a Windows user account. |
| Control Name | Description |
|---|---|
| Email address | Type the name of the email address for the account. This is the email address that email is sent from, and it must be in the format email_name@domain_name. An example email address is sales@contoso.com. |
| Display name | Optional setting. Type the name to display on email messages sent from this account. An example display name is Contoso Sales Group. |
| Reply email address | Optional setting. Type the email address to use for replies to email messages sent from this account. An example reply email address is admin@contoso.com. |
| SMTP server | Type the name or IP address of the SMTP server the account uses to send email. 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). |
Database Mail can be sent by using the credentials of the [!INCLUDEssDEnoversion], by using other credentials that you supply, or anonymously. As a best practice, if your email 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 [!INCLUDEssNoVersion] [!INCLUDEssDEnoversion] 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 email server, and the account need not correspond to a [!INCLUDEssNoVersion] user or user on the computer running [!INCLUDEssNoVersion]. |
| 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. |
Database Configuration Page (Master Data Services Configuration Manager)
Set up the Database and Website for Master Data Services