The next posts will focus on installing and configuring BizTalk Server 2013 R2 and additional components
Make sure that you have installed all the latest critical Windows updates from Microsoft and all the prerequisites before you install BizTalk Server 2013 R2.
📝 One-Minute Brief
This article shows how to validate the SQL Server Database Mail account that BizTalk Server 2013 R2 uses to send BAM Alerts. It explains how to test the configured mail account and verify that SQL Server can successfully send email notifications before you enable BizTalk alerts.
Validate the Mail account used by BizTalk to send BAM Alerts
After you configure BizTalk Server 2013 R2 BAM Alerts successfully, 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 the Start screen, type SQL Management or SQL, and click on the SQL Server Management Studio option from the Search menu.
- In the Object Explorer panel, connect to the SQL Server instance you want to configure Database Mail on. And then 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 the 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.
- On the Complete the Wizard page, click Finish.
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 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 Server 2013 R2: Installation and Configuration – Important considerations before set up the server (Part 1)
- BizTalk Server 2013 R2: Installation and Configuration – Enable Internet Information Services (Part 2)
- BizTalk Server 2013 R2: Installation and Configuration – Install Windows Identity Foundation (WIF) (Part 3)
- BizTalk Server 2013 R2: Installation and Configuration – Install and configure SMTP Server Feature (optional) (Part 4)
- BizTalk Server 2013 R2: Installation and Configuration – Install Microsoft Office Excel 2013 (Part 5)
- BizTalk Server 2013 R2: Installation and Configuration – Install Visual Studio 2013 (Part 6)
- BizTalk Server 2013 R2: Installation and Configuration – Install SQL Server 2014 (Part 7)
- BizTalk Server 2013 R2: Installation and Configuration – Configure SQL Server Database Mail feature (Part 8)
- BizTalk Server 2013 R2: Installation and Configuration – Install and Configure BizTalk Server 2013 R2 (Part 9)
- BizTalk Server 2013 R2: Installation and Configuration – Configure SQL Server Network Configuration protocols (Part 10)
- BizTalk Server 2013 R2: Installation and Configuration – Installing BizTalk Adapter Pack (Part 12)
- BizTalk Server 2013 R2: Installation and Configuration – Install and Configure Microsoft UDDI Services (Part 13)
- BizTalk Server 2013 R2: Installation and Configuration – Install and Configure the Microsoft BizTalk ESB Toolkit (Part 14)
- BizTalk Server 2013 R2: Installation and Configuration – Configure BizTalk Server SQL Jobs (Part 15)
- BizTalk Server 2013 R2: Installation and Configuration – Optimize the BizTalk Server 2013 R2 environment (Part 16)
- BizTalk Server 2013 R2: Installation and Configuration – Optimize the BizTalk Server 2013 R2 environment (Part 17)
- BizTalk Server 2013 R2: Installation and Configuration – Optimize the BizTalk Server 2013 R2 environment (Part 18)
- BizTalk Server 2013 R2: Installation and Configuration – Install additional Developer tools (Part 19)
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.
It would be good to know how what are the “configuration pieces” are responsible for picking the BAM message based on the alert definition, and routing that message to the Database Mail, so that it could be sent out as email delivery.
The issue I am having is, I mistakenly deleted the profile created by the Configuration, and thus don’t see any BAM alert emails flowing out.
Yet I can receive the test emails sent thru Database Mail/Send Test Email opton. Also, in the BAM portal, the BAM alerts filter query correctly identifies the BAM messages, that should have been picked for alerts.
Wondering what changes need to be done to synchronize my Database Mail setup with BizTalk BAM, without bringing down the entire BAM setup including the BAM Portal configuration, done thru BizTalk Configuration.