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

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

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.
  4. Review the information on the Setup Support Rules screen, and then click OK.
  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 needs to be opened if you plan to access your SQL Server installation from outside. Read more at
  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
  9. On the Instance Configuration screen, select Default instance, and then click Next.
  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.
  12. On the Database Engine Configuration screen, select Windows authentication mode, click Add Current User, and then click Next.
  13. On the Analysis Services Configuration screen, click Add Current User, and then click Next.
  14. On the Reporting Services Configuration screen, select Install the native mode default configuration, and then click Next.
  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.
  18. On the Installation Progress screen, after setup has finished, click Next.
  19. On the Complete screen, click Close.

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

Related links

Tags: BizTalk 2010 | Installation | Configuration

  1. […] Server 2008 R2 kurulumu için… sitesinden faydalanabilirsiniz. Burada Account belirlerken Local Account yerine domain […]

  2. Mark Phillips says:

    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?

  3. Nigel says:

    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

Fill in your details below or click an icon to log in: Logo

You are commenting using your 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