BizTalk 2010 Installation and Configuration – Install SQL Server 2008 R2 (Part 4)

Posted: October 21, 2010  |  Categories: BizTalk

BizTalk Server provides the capability to specify a business process and also a mechanism by which the applications used in that business process can communicate with each other. SQL Server is the main repository for this communication mechanism. You must install SQL Server 2008 R2/SP1 (Enterprise Edition is recommended).


BAM real-time aggregation (RTA) is not supported in SQL Server 2008 R2/SP1 Standard Edition. In order to use BAM RTA, you must install SQL Server 2008 R2/SP1 Enterprise Edition.

In my case, I will use SQL Server 2008 R2.

To install SQL Server 2008 R2

  1. Insert the SQL Server 2008 R2 installation disk into the DVD-ROM drive. The setup program will begin automatically. If prompted for automatic installation of prerequisite software, click OK.
  2. On the SQL Server Installation Center, click Installation.
  3. Click New Installation or Add Features to an Existing Installation.
    install sql new installation
  4. Review the information on the Setup Support Rules screen, and then click OK.
    install sql rules
  5. On the Product Key screen, enter your product key and click Next.
  6. On the License Terms screen, select I accept the license terms and then click Next.
  7. On the Setup Support Files screen, click Install.
    1. You will probably get a warning for the Windows Firewall. That is because some ports need to be opened if you plan to access your SQL Server installation from outside. Read more here
      install sql firewall warning
  8. On the Feature Selection screen, select the following features, and then click Next.
    1. Database Engine Services
      1. SQL Server Replication
      2. Full-Text Search
    2. Analysis Services
    3. Reporting Services
    4. Shared Features
      1. Business Intelligence Development Studio
      2. Client Tools Connectivity
      3. Integration Services
      4. Management Tools – Basic
        1. Management Tools – Complete
          install sql features
  9. On the Instance Configuration screen, select Default instance, and then click Next.
    install sql Instance Configuration screen
  10. Review the information on the Disk Space Requirements screen, and then click Next.
  11. On the Server Configuration screen, click Use the same account for all SQL Server instances, enter a local account or domain account and password, and then click Next.
    install sql Server Configuration screen
  12. On the Database Engine Configuration screen, select Windows authentication mode, click “Add Current User”, and then click Next.
    install sql Database Engine Configuration screen
  13. On the Analysis Services Configuration screen, click “Add Current User”, and then click Next.
    install sql Analysis Services Configuration screen
  14. On the Reporting Services Configuration screen, select Install the native mode default configuration, and then click Next.
    install sql Reporting Services Configuration screen
  15. On the Error and Usage Reporting screen, leave the default values, and then click Next.
  16. On the Installation Rules screen, review the information and resolve any issues, and then click Next.
  17. On the Ready to Install screen, review the information, and then click Install.
    install sql Ready to Install screen
  18. On the Installation Progress screen, after setup has finished, click Next.
  19. On the Complete screen, click Close.
    install sql completed screen

Note: Once again, after this installation, I like to do a Windows update, this step is not necessary.

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.

7 thoughts on “BizTalk 2010 Installation and Configuration – Install SQL Server 2008 R2 (Part 4)”

  1. I am installing BizTalk Developer Edition. I want to learn BAM. I am finding an issue with the installation of X64 Package (sqlncli_x64.msi) l get an error indicating that I have a higher version already existing and that it must be removed. It looks like it would be the version in 2008 R2 SP1. I followed both your directions and the directions in the MS Installation Document.

    How do I uninstall that specific component and what are the consequences upon any non BizTalk applications that may want to use Sql Server R2 SP1 in my DEV environment?

    1. Hi Mark,

      Sorry for the delay… SQL Server 2008 or 2008 R2 don’t have SQL Server Notification Services included, but because BAM Notification needs SQL Server Notification Services we have to install SQL Server Notification 2005 Services (sqlncli_x….msi) on top of SQL Server 2008 or 2008 R2.
      Make sure what SQL Server 2008 R2 version you have installed (32 or. 64 bits) and install the correct version of SQL Server Notification 2005 Services see my post:

      And also go to “Programs and features” and check if you have previous versions installed, maybe old SQL Express and so on, if they exist remove them first..

  2. Thanks for these posts, Sandro,

    It would be good if we could have a definitive guide on just what is needed by BizTalk, so we can setup development and test domains without just installing everything like you advise.

    For example, I know that SQL Reporting Server is not used, and I suspect that SQL Replication probably isn’t needed as well.

    Installing everything has the side effect of causing issues with SysPrep which makes things harder if you want to produce a VM template.

    Any thoughts on what would be the minimum steps needed?



Leave a Reply

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


Back to Top