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
- 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.
- On the SQL Server Installation Center, click Installation.
- Click New Installation or Add Features to an Existing Installation.
- Review the information on the Setup Support Rules screen, and then click OK.
- On the Product Key screen, enter your product key and click Next.
- On the License Terms screen, select I accept the license terms and then click Next.
- On the Setup Support Files screen, click Install.
- 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
- 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
- On the Feature Selection screen, select the following features, and then click Next.
- Database Engine Services
- SQL Server Replication
- Full-Text Search
- Analysis Services
- Reporting Services
- Shared Features
- Business Intelligence Development Studio
- Client Tools Connectivity
- Integration Services
- Management Tools – Basic
- Management Tools – Complete
- Management Tools – Complete
- Database Engine Services
- On the Instance Configuration screen, select Default instance, and then click Next.
- Review the information on the Disk Space Requirements screen, and then click Next.
- 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.
- On the Database Engine Configuration screen, select Windows authentication mode, click “Add Current User”, and then click Next.
- On the Analysis Services Configuration screen, click “Add Current User”, and then click Next.
- On the Reporting Services Configuration screen, select Install the native mode default configuration, and then click Next.
- On the Error and Usage Reporting screen, leave the default values, and then click Next.
- On the Installation Rules screen, review the information and resolve any issues, and then click Next.
- On the Ready to Install screen, review the information, and then click Install.
- On the Installation Progress screen, after setup has finished, click Next.
- 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
- BizTalk 2010 Installation and Configuration – Enable Internet Information Services (Part 1)
- BizTalk 2010 Installation and Configuration – Install Microsoft Office Excel 2007 (Part 2)
- BizTalk 2010 Installation and Configuration – Install Visual Studio 2010 (Part 3)
- BizTalk 2010 Installation and Configuration – Install SQL Server 2008 R2 (Part 4)
- BizTalk 2010 Installation and Configuration – Install SQL Server 2005 Notification Services on top of SQL Server 2008 R2 (Part 5)
- BizTalk 2010 Installation and Configuration – Install and Configure Windows SharePoint Services (Part 6)
- BizTalk 2010 Installation and Configuration – Install and Configure SharePoint Foundation 2010 (Part 6.1)
- BizTalk 2010 Installation and Configuration – Disable the Shared Memory Protocol (Part 7)
- BizTalk 2010 Installation and Configuration – Installing and Configuring BizTalk Server (Part 8 )
- BizTalk 2010 Installation and Configuration – Installing and configuring local SMTP for Reporting Server (Part 9)
- BizTalk 2010 Installation and Configuration – Installing BizTalk Adapter Pack 2010 and BizTalk AppFabric Connect feature (Part 10)
- BizTalk 2010 Installation and Configuration – Configure BizTalk Server SQL Jobs (Part 11)
- BizTalk 2010 Installation and Configuration – Enable TCP/IP, Named Pipes protocols and DTC on the Local Host Server (Part 12)
- BizTalk 2010 Installation and Configuration – Configure the Application Event Log (Part 13)
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?
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: http://sandroaspbiztalkblog.wordpress.com/2010/10/21/biztalk-2010-installation-and-configuration-install-sql-server-2005-notification-services-on-top-of-sql-server-2008-r2-part-5/
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..
Thanks for the reply Sandro. Another user informed me that the link in the “”Installing BizTalk Server 2010 on Windows 7 and Windows Vista”. ” documentation for SQL Server Notification Services was wrong. Below is the correct link.
http://www.microsoft.com/en-us/download/details.aspx?id=20101
Feature Pack for Microsoft SQL Server 2005 SP4
It worked. Thanks again.
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.