If you are using BizTalk Server 2009 and want to use BAM alerts, you will still need notification services.
Business Notification can run on SQL Server 200,8 provided that the following two components are also installed:
- SQL Server Notification Services 2005
- SQL Server 2005 Service Pack 3.
Notes:
- Notification Services is no longer part of SQL Server 2008.
- SQL Server 2005 Service Pack 3 allows Notification Services 2005 to run with the SQL Server 2008 database engine. For further information, please also refer to What’s New in SQL Server 2005 SP3: https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2005/dd353312(v=sql.90).
📝 One-Minute Brief
Setting up BAM Alerts in BizTalk Server with SQL Server 2008 requires installing SQL Server Notification Services, which is no longer part of the standard SQL installation. This guide covers the essential steps: installing the SQL 2005 Notification Services components.
Installation process in order to use SQL Server 2008
Installation steps:
- Install SQL Server 2008.
- Install SQL Server 2005 Notification Services only.
- When SQL Server 2005 setup starts, a list of installation components is displayed.
- Select Notification Services only and complete the installation.
- Apply SQL Server 2005 Service Pack 3.
- This can be downloaded from here: https://www.microsoft.com/en-us/download/details.aspx?id=17667.
While SQL Server 2008 made BAM Alerts more complex by removing Notification Services, the functionality is still fully supported if you install the legacy compatibility components. Once configured, your business users can again define custom alerts directly in the BAM Portal.
