In Part 8, we configured SQL Server Database Mail. Now, we must ensure that the BizTalk BAM Alert infrastructure can successfully call that mail profile. If these settings aren’t validated, your BAM activities will be tracked, but no one will receive the notifications.
📝 One-Minute Brief
After configuring SQL Server Database Mail, it is essential to ensure that the BizTalk BAM (Business Activity Monitoring) infrastructure can actually utilize it. This guide focuses on verifying the security permissions for the SQL Mail Profile, specifically ensuring it is set as “Public” and “Default.” Validating this step is the only way to guarantee that automated BAM alerts will reach their recipients without being blocked by SQL Server security settings.
After you configure with success BizTalk Server 2013 BAM Alerts, the configurator will create a new Database Mail Account called BAM_Alerts_Account that will be used by BizTalk to send BAM Alerts. To validate the Mail account used by BizTalk to send BAM Alerts:
- Press the Windows key to switch to Metro UI and type SQL Management or SQL, and click on the SQL Server Management Studio option on the Apps menu.
- In the Object Explorer panel, connect to the SQL Server instance you want to configure Database Mail on and expand the server tree.
- Expand the Management node and double-click Database Mail to open the Database Mail Configuration Wizard.
- On the Welcome to Database Mail Configuration Wizard page, click Next to continue.
- On the Select Configuration Task page, select the Manage Database Mail accounts and profiles option and click Next.
- On the Manage Profiles and Accounts page, select View, change or delete an existing account option, and click Next.

- On the Manage Existing Account page, select the BAM_Alerts_Account option under Account name and validate the configuration. After that, click Next to make any changes or Cancel to exit.

Finally, you should test sending an email with this Database Mail Account. To do that:
- Right-click on Database Mail and select Send Test E-Mail…

- On the Send Test E-mail from <server> window, specify a To: email and click Send Test E-Mail.

If all goes well, you should receive the email in a few seconds. If you have received the email, you have been able to configure Database Mail successfully.
Related links
- BizTalk 2013 Installation and Configuration – Important considerations before set up the server (Part 1)
- BizTalk 2013 Installation and Configuration – Enable Internet Information Services (Part 2)
- BizTalk 2013 Installation and Configuration – Install Windows Identity Foundation (Part 3)
- BizTalk 2013 Installation and Configuration – Install and configure SMTP Server Feature (Part 4)
- BizTalk 2013 Installation and Configuration – Install Microsoft Office Excel 2013 (Part 5)
- BizTalk 2013 Installation and Configuration – Install Visual Studio 2012 (Part 6)
- BizTalk 2013 Installation and Configuration – Install SQL Server 2012 (Part 7)
- BizTalk 2013 Installation and Configuration – Configure SQL Server Database Mail feature (Part 8)
- BizTalk 2013 Installation and Configuration – Install and Configure BizTalk Server 2013 (Part 9)
- BizTalk 2013 Installation and Configuration – Configure SQL Server Network Configuration protocols (Part 10)
- BizTalk 2013 Installation and Configuration – Installing BizTalk Adapter Pack (Part 12)
- BizTalk 2013 Installation and Configuration – Install and Configure Microsoft UDDI Services (Part 13)
- BizTalk 2013 Installation and Configuration – Install and Configure the Microsoft BizTalk ESB Toolkit (Part 14)
- BizTalk 2013 Installation and Configuration – Configure BizTalk Server SQL Jobs (Part 15)
- BizTalk 2013 Installation and Configuration – Configure BizTalk Server Windows Services (Part 16)
Hope you find this helpful! If you liked the content or found it useful and would like to support me in writing more, consider buying (or helping to buy) a Star Wars Lego set for my son.
2 thoughts on “BizTalk 2013 Installation and Configuration – Validate Mail account used by BizTalk to send BAM Alerts (Part 11)”