BAM Portal Configurations - Configure BAM Alerts (SQL Notification Services) on SQL Server 2008 – SANDRO PEREIRA BIZTALK BLOG

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 2008 provided that the 2 following components are also installed:

• SQL Server Notification Services 2005
• SQL Server 2005 Service Pack 3.

Notification Services is no longer part of SQL Server 2008. What SQL Server 2005 Service Pack 3 does is that it 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).

Installation process in order to use SQL Server 2008

Installation steps:

1. Install SQL Server 2008.
2. Install SQL Server 2005 Notification Services only. When the SQL Server 2005 setup is started, a list of installation components is available. Selected Notification Services only and complete the installation.
3. Apply SQL Server 2005 Service Pack 3. This can be downloaded from here: https://www.microsoft.com/en-us/download/details.aspx?id=17667.

References

• http://social.msdn.microsoft.com/Forums/en-CA/biztalkgeneral/thread/96e7be81-afca-4030-a831-6e936940c6e5