In general when building a new BizTalk Server environment it is best to follow the installation guides provided by Microsoft with each release of its product but from time to time even following the instructions will result in errors.
When building my BizTalk 2010 environment I encountered such an error when trying to configure BAM, Hopefully reading this post will save you some valuable time.
As specified by the installation guide, if you plan to configure BAM alerts you will need to install SQL Notification Services. This feature of SQL Server stopped shipping after the release of SQL Server 2005.
To get this feature working you will need to disregard the instructions as outlined in the BizTalk 2010 installation guide and follow these alternative instructions:
Before installing SQL Server 2008 R2 install the following:
- SQL Server 2005 Notification Services (from the a copy of the SQL 2005 installation iso)
- SQL Server 2005 SP2.
- SQL Server 2005 SP3.