BizTalk 2010 Installation and Configuration – Install SQL Server 2005 Notification Services on top of SQL Server 2008 R2 (Part 5)

Posted: October 21, 2010  |  Categories: BizTalk

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.

To install SQL Server 2005 Notification Services

  • Click or navigate to the Feature Pack for Microsoft SQL Server 2005 – December 2008 ( https://www.microsoft.com/en-us/download/details.aspx?id=24793).
  • 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)

In my case, I used x64 components.

To install the Microsoft SQL Server Native Client

  1. Execute “sqlncli_x64.msi”
  2. On the Welcome screen, click Next.
  3. On the License Terms screen, select I accept the license terms and then click Next.
  4. On the Registration Information screen, enter your name and company in their respective fields, and then click Next
  5. On the Feature Selection screen, select the following features, and then click Next.
    1. Client Components
      SQL-Server-Native_Client-features
  6. On the Ready to Install screen, click Install.

To install Microsoft SQL Server 2005 Management Objects Collection

  1. Execute “SQLServer2005_XMO_x64.msi”
  2. On the Welcome screen, click Next.
  3. On the License Terms screen, select I accept the license terms and then click Next.
  4. On the Registration Information screen, enter your name and company in their respective fields, and then click Next
  5. On the Ready to Install screen, click Install.

To install Microsoft SQL Server 2005 Notification Services Client Components

  1. Execute “SQLServer2005_NS_x64.msi”
  2. On the Welcome screen, click Next.
  3. On the License Terms screen, select I accept the license terms and then click Next.
  4. On the Registration Information screen, enter your name and company in their respective fields, and then click Next
  5. On the Ready to Install screen, click Install.

Related links

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.

8 thoughts on “BizTalk 2010 Installation and Configuration – Install SQL Server 2005 Notification Services on top of SQL Server 2008 R2 (Part 5)”

  1. 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 ?

      1. Hi Sandra,

        thank you very much for your fast reply !
        And thank you for this blog which is a precious resource about BizTalk !

        Regards.

Leave a Reply

Your email address will not be published. Required fields are marked *

BizTalk360
BizTalk Server

Over 500+ customers across
30+ countries depend on BizTalk360

Learn More
Serverless360
Azure

Manage and monitor serverless
components effortlessly

Learn More
Atomicscope
Business Users

Monitor your Business Activity in iPaaS
or Hybrid integration solutions

Learn More

Back to Top