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).

Important

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 at http://go.microsoft.com/fwlink/?LinkId=94001
      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

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.

  • Pingback: Biztalk Server 2010 Kurulumu–SQL Server`ın hazırlanması | Microsoft günlükleri by barisca()

  • Pingback: Biztalk Server 2010 Kurulumu – SQL Server Ayarları | Mshowto()

  • Mark Phillips

    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?

  • Pingback: Biztalk Server 2010 Kurulumu için SQL Server’ın Hazırlanması Nasıl Yapılır | Mshowto()

  • Nigel

    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?

    Thanks,

    Nigel.

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