If you plan to use BAM Alerts in your BizTalk Server project, you must install SQL Notification Services and its prerequisites on your BizTalk Server computer. This SQL Server 2005 feature is not included in SQL Server 2008 R2/SP1, but you can install it from the Microsoft Download Center.
📝 One-Minute Brief
BizTalk Server 2010’s Business Activity Monitoring (BAM) Alerts feature relies on the SQL Server 2005 Notification Services engine. Since this was discontinued in SQL Server 2008 R2, you must manually install the legacy components from the SQL Server 2005 Feature Pack. This post explains which specific files to download (SQLServer2005_NS.msi) and how to install them on top of your newer SQL instance to ensure BAM Alerts function correctly.
To install SQL Server 2005 Notification Services
- Click or navigate to the Feature Pack for Microsoft SQL Server 2005 – December 2008.
- Depending on your platform, download the appropriate package from the following three components :
- Microsoft SQL Server Native Client
- X86 Package (sqlncli.msi)
- X64 Package (sqlncli_x64.msi)
- Microsoft SQL Server 2005 Management Objects Collection
- X86 Package (SQLServer2005_XMO.msi)
- X64 Package (SQLServer2005_XMO_x64.msi)
- Microsoft SQL Server 2005 Notification Services Client Components
- X86 Package (SQLServer2005_NS.msi)
- X64 Package (SQLServer2005_NS_x64.msi)
- Microsoft SQL Server Native Client
In my case, I used x64 components.
To install the Microsoft SQL Server Native Client
- Execute sqlncli_x64.msi.
- On the Welcome screen, click Next.
- On the License Terms screen, select I accept the license terms and then click Next.
- On the Registration Information screen, enter your name and company in their respective fields, and then click Next.
- On the Feature Selection screen, select the following features, and then click Next.
- Client Components
- On the Ready to Install screen, click Install.
To install Microsoft SQL Server 2005 Management Objects Collection
- Execute SQLServer2005_XMO_x64.msi.
- On the Welcome screen, click Next.
- On the License Terms screen, select I accept the license terms and then click Next.
- On the Registration Information screen, enter your name and company in their respective fields, and then click Next.
- On the Ready to Install screen, click Install.
To install Microsoft SQL Server 2005 Notification Services Client Components
- Execute SQLServer2005_NS_x64.msi.
- On the Welcome screen, click Next.
- On the License Terms screen, select I accept the license terms and then click Next.
- On the Registration Information screen, enter your name and company in their respective fields, and then click Next.
- On the Ready to Install screen, click Install.
Related links
- BizTalk 2010 Installation and Configuration – Enable Internet Information Services (Part 1)
- BizTalk 2010 Installation and Configuration – Install Microsoft Office Excel 2007 (Part 2)
- BizTalk 2010 Installation and Configuration – Install Visual Studio 2010 (Part 3)
- BizTalk 2010 Installation and Configuration – Install SQL Server 2008 R2 (Part 4)
- BizTalk 2010 Installation and Configuration – Install SQL Server 2005 Notification Services on top of SQL Server 2008 R2 (Part 5)
- BizTalk 2010 Installation and Configuration – Install and Configure Windows SharePoint Services (Part 6)
- BizTalk 2010 Installation and Configuration – Install and Configure SharePoint Foundation 2010 (Part 6.1)
- BizTalk 2010 Installation and Configuration – Disable the Shared Memory Protocol (Part 7)
- BizTalk 2010 Installation and Configuration – Installing and Configuring BizTalk Server (Part 8 )
- BizTalk 2010 Installation and Configuration – Installing and configuring local SMTP for Reporting Server (Part 9)
- BizTalk 2010 Installation and Configuration – Installing BizTalk Adapter Pack 2010 and BizTalk AppFabric Connect feature (Part 10)
- BizTalk 2010 Installation and Configuration – Configure BizTalk Server SQL Jobs (Part 11)
- BizTalk 2010 Installation and Configuration – Enable TCP/IP, Named Pipes protocols and DTC on the Local Host Server (Part 12)
- BizTalk 2010 Installation and Configuration – Configure the Application Event Log (Part 13)
Thanks for putting it out clearly.. Cheers.
Way better is to install Client code from SQL Server DVD, No surprises, and works like a charm.
Helpfull
Hello,
thanks a lot for all this useful information !
Just wondering, in case when SQL 2008 R2 and BizTalk 2010 are on different servers, on which one should I install Notification Services ? On SQL server or on BizTalk server ?
Hi Steve,
You should install Notifications Services on the BizTalk server.
Check: http://sandroaspbiztalkblog.wordpress.com/2012/01/08/installing-biztalk-server-2010-in-a-basic-multi-computer-environment-preparing-and-install-prerequisites-on-biztalk-server-2010-machine-part-5/
Or: http://social.technet.microsoft.com/wiki/contents/articles/6845.how-to-install-biztalk-server-2010-in-a-basic-multi-computer-environment.aspx
Hi Sandra,
thank you very much for your fast reply !
And thank you for this blog which is a precious resource about BizTalk !
Regards.
Sorry, I meant Sandro, obviously !
Thanks for this article! found it useful!