Geeks With Blogs
Edmund Zhao's BizTalk abc We share, We learn

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 a great article 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

Posted on Wednesday, February 1, 2006 9:30 AM | Back to top

Comments on this post: Achieve BizTalk Server 2004 high availability by clustering SQL Server, Analysis Services and Enterprise Single Sign-On

No comments posted yet.
Your comment:
 (will show your gravatar)

Copyright © Edmund Zhao | Powered by: