Achieve BizTalk Server 2004 high availability by clustering SQL Server, Analysis Services and Enterprise Single Sign-On

February 1, 2006 · 1 min read

BizTalk Server 2004 is not cluster aware, therefore it is not recommended to install BizTalk 2004 on a MSCS based server cluster. However, to achieve high availability of you BizTalk solution, you can still take the following actions. (I assume you are installing BizTalk 2004, SQL Server 2000 on Windows Server 2003)

1. Setup an Active\Passive server cluster based on Microsoft Cluster Services Install SQL Server 2000 with service pack 3a on the cluster. This step is very easy because SQL Server 2000 fully support MSCS. The following is from Brad M. McGehee telling you all the details. The article was talking about intalling SQL server 2000 on Windows Server 2000, not Windows Server 2003, but it makes no big difference.

2. Install SQL Server 2000 Analysis Services with service pack 3a on the cluster. This step is a little bit complicated because Analysis Services is not cluster-awared. Lots of manual processes will be involved during installation. The following is the detail instruction of installation. The instruction doesn’t mention when and how to install service pack 3a. You need to be ware of that and try to apply the service pack before manually modify things like registry.

3. Install Microsoft Single Sign-On Master Secret Server. This step won’t be too complicated if you have already experienced the installation of Analysis Service cluster. You can follow the instruction below in a great article provided by Mike H.

4. Test them by moving groups in Cluster Administrator

...Edmund Zhao

This article is part of the GWB Archives. Original Author: Edmund Zhao

New on Geeks with Blogs

  • We Won The One Award I Actually Care About

    Full Scale made the Inc. 5000 for the fifth year straight, the 12th listing across my three companies. Here is why the one award you cannot buy is worth stopping for.

  • Your Customers Build the Features Now

    I let a tool I liked sit dead for a year rather than build the features I wanted. An MCP server meant I never had to, and your customers can do the same to your product.

  • Get the Size of a Directory in Linux the Easy Way

    du -sh for the quick answer, ncdu for the cleanup, df for the disk itself: every command for checking directory size in Linux, plus why du and df never agree.

  • Vim Search and Replace: The Ultimate Guide

    One :%s command replaces every match in a file before a find dialog would even open. The Vim substitute patterns worth the muscle memory: flags, ranges, capture groups, and multi-file edits.