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 (http://go.microsoft.com/fwlink/?LinkId=154501).
  • 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 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

Tags: BizTalk 2010 | Installation | Configuration

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.

One Platform Operations, Monitoring and Analytics Software
BizTalk360

microsoft biztalk

Learn more

Over 500 customers across 30+ countries depend on BizTalk360

ServiceBus360

Azure service bus

Learn more

Start managing your Azure Service Bus namespaces in minutes

One Platform - Operations, Monitoring and Analytics Software
BizTalk360

microsoft biztalk

Learn more

Over 500 customers across 30+ countries depend on BizTalk360

One Platform - Operations, Monitoring and Analytics Software
ServiceBus360

Azure service bus

Learn more

Start managing your Azure Service Bus namespaces in minutes

Back to Top