BAM Portal Configurations – Configure BAM Alerts (SQL Notification Services) on SQL Server 2008

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

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. View all posts by Sandro Pereira