| Author | Chrissy LeMaire (@cl), netnerds.net |
| Availability | Windows, Linux, macOS |
Want to see the source code for this command? Check out New-DbaDbMailAccount on GitHub.
Want to see the Bill Of Health for this command? Check out New-DbaDbMailAccount.
Creates a new Database Mail account for sending emails from SQL Server
Creates a new Database Mail account on SQL Server instances to enable automated email notifications, alerts, and reports. Database Mail accounts define the email settings (SMTP server, sender address, authentication) that SQL Server uses when sending emails through stored procedures like sp_send_dbmail. This is essential for setting up automated maintenance notifications, job failure alerts, and scheduled report delivery.
New-DbaDbMailAccount
[-SqlInstance] <DbaInstanceParameter[]>
[[-SqlCredential] <PSCredential>]
[-Account] <String>
[[-DisplayName] <String>]
[[-Description] <String>]
[-EmailAddress] <String>
[[-ReplyToAddress] <String>]
[[-MailServer] <String>]
[-Force]
[-EnableException]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
PS C:\> $account = New-DbaDbMailAccount -SqlInstance sql2017 -Account 'The DBA Team' -EmailAddress [email protected] -MailServer smtp.ad.local
Creates a new database mail account with the email address [email protected] on sql2017 named "The DBA Team" using the smtp.ad.local mail server.
The target SQL Server instance or instances. You must have sysadmin access and server version must be SQL Server version 2008 or higher.
| Alias | |
| Required | True |
| Pipeline | true (ByValue) |
| Default Value |
Specifies the unique name for the Database Mail account being created. This name is used internally by SQL Server to identify the account when configuring Database Mail profiles.
Choose a descriptive name that identifies the account's purpose, such as 'MaintenanceAlerts' or 'ReportDelivery'.
| Alias | Name |
| Required | True |
| Pipeline | false |
| Default Value |
Specifies the sender email address that appears in outgoing messages from this Database Mail account. This must be a valid email address that your SMTP server accepts.
Use addresses that recipients will recognize and trust, such as '[email protected]' or '[email protected]'.
| Alias | |
| Required | True |
| Pipeline | false |
| Default Value |
Login to the target instance using alternative credentials. Accepts PowerShell credentials (Get-Credential).
Windows Authentication, SQL Server Authentication, Active Directory - Password, and Active Directory - Integrated are all supported.
For MFA support, please use Connect-DbaInstance.
| Alias | |
| Required | False |
| Pipeline | false |
| Default Value |
Sets the friendly name that appears in the 'From' field of outgoing emails. Recipients see this name instead of the raw account name.
Defaults to the Account name if not specified. Use descriptive names like 'SQL Server Alerts' or 'DBA Team Notifications'.
| Alias | |
| Required | False |
| Pipeline | false |
| Default Value | $Account |
Provides optional documentation text describing the account's purpose and usage. This helps other DBAs understand when and how the account should be used.
Consider including details like which jobs or applications use this account and any special configuration requirements.
| Alias | |
| Required | False |
| Pipeline | false |
| Default Value |
Specifies an alternate email address for replies when different from the sender address. Recipients who reply to automated emails will send responses to this address instead.
Useful when you want replies to go to a monitored mailbox like '[email protected]' rather than the automated sender address.
| Alias | |
| Required | False |
| Pipeline | false |
| Default Value |
Specifies the SMTP server hostname or IP address that SQL Server will use to send emails through this account. The server must be accessible from the SQL Server instance.
If not specified, uses the SQL Server instance name as the mail server. The function validates that the mail server exists unless -Force is used.
| Alias | |
| Required | False |
| Pipeline | false |
| Default Value |
Bypasses the mail server existence validation and creates the Database Mail account even if the specified SMTP server cannot be found or verified.
Use this when the mail server exists but is not discoverable by SQL Server, or when setting up accounts for servers that will be available later.
| Alias | |
| Required | False |
| Pipeline | false |
| Default Value | False |
By default, when something goes wrong we try to catch it, interpret it and give you a friendly warning message.
This avoids overwhelming you with "sea of red" exceptions, but is inconvenient because it basically disables advanced scripting.
Using this switch turns this "nice by default" feature off and enables you to catch exceptions with your own try/catch.
| Alias | |
| Required | False |
| Pipeline | false |
| Default Value | False |
If this switch is enabled, no actions are performed but informational messages will be displayed that explain what would happen if the command were to run.
| Alias | wi |
| Required | False |
| Pipeline | false |
| Default Value |
If this switch is enabled, you will be prompted for confirmation before executing any operations that change state.
| Alias | cf |
| Required | False |
| Pipeline | false |
| Default Value |