BizTalk 2013 Installation and Configuration – Validate Mail account used by BizTalk to send BAM Alerts (Part 11)

  • Sandro Pereira
  • May 20, 2013
  • 3 min read

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.
BizTalk Server 2013 BAM Database Mail Manage Profiles and Accounts page
  • 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.
BizTalk Server 2013 BAM Database Mail Manage Existent Account page

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…
BizTalk Server 2013 BAM Database Mail Send Test E-Mail
  • On the Send Test E-mail from <server> window, specify a To: email and click Send Test E-Mail.
BizTalk Server 2013 BAM Database Mail Send Test E-Mail details

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

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. 

Thanks for Buying me a coffe
Author: Sandro Pereira

Sandro Pereira lives in Portugal and works as a consultant at DevScope. In the past years, he has been working on implementing Integration scenarios both on-premises and cloud for various clients, each with different scenarios from a technical point of view, size, and criticality, using Microsoft Azure, Microsoft BizTalk Server and different technologies like AS2, EDI, RosettaNet, SAP, TIBCO etc. He is a regular blogger, international speaker, and technical reviewer of several BizTalk books all focused on Integration. He is also the author of the book “BizTalk Mapping Patterns & Best Practices”. He has been awarded MVP since 2011 for his contributions to the integration community.

2 thoughts on “BizTalk 2013 Installation and Configuration – Validate Mail account used by BizTalk to send BAM Alerts (Part 11)”

Leave a Reply

Your email address will not be published. Required fields are marked *

The Ultimate Cloud
Management Platform for Azure

Supercharge your Azure Cost Saving

Learn More
Turbo360 Widget

Back to Top