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

Posted: October 21, 2010 in BizTalk
Tags: , ,

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

Comments
  1. Zeeshan says:

    Thanks for putting it out clearly.. Cheers.

  2. Emil says:

    Way better is to install Client code from SQL Server DVD, No surprises, and works like a charm.

  3. Bhava says:

    Helpfull

  4. Steve says:

    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 ?

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