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

Posted: March 5, 2010 in BizTalk
Tags: , , ,

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”: http://msdn.microsoft.com/en-us/library/dd353312(SQL.90).aspx

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: http://www.microsoft.com/downloads/details.aspx?FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4&displaylang=en

References:

Tags: BizTalk | BAM | Alerts | Configurations

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s