Microsoft KB Archive/935191

= How to install and how to configure Host Integration Server 2006 in a clustered SQL Server environment =

Article ID: 935191

Article Last Modified on 5/2/2007

-

APPLIES TO


 * Microsoft Host Integration Server 2006

-



INTRODUCTION
This article discusses how to install and how to configure Microsoft Host Integration Server 2006 in a clustered Microsoft SQL Server environment. By itself, Host Integration Server 2006 is not a cluster-aware product. However, when you run the Host Integration Server 2006 Configuration Tool, you can specify a clustered instance of SQL Server instead of a stand-alone instance of SQL Server. If you are using domain security groups, no additional steps are required. However, if you are using local security groups, you must complete additional steps to make sure that Host Integration Server 2006 works correctly.



MORE INFORMATION
When you configure Host Integration Server 2006 by using the Host Integration Server 2006 Configuration Tool, you can specify the name of a remote installation of SQL Server. Standard roles will be created on the installation of SQL Server. These roles contain the HIS Runtime security group and the HIS Administrator security group. These groups are specified on the Common Settings page of the Host Integration Server 2006 Configuration Tool. If these groups are local security groups, local security groups of the same name will be created on the remote installation of SQL Server. In a clustered SQL Server environment, these groups are created only on the active cluster node. For Host Integration Server 2006 to function after the active cluster node fails, you must do the following. Manually duplicate the local security groups and their members that were created on the active SQL Server cluster node to all the remaining SQL Server cluster nodes. This will make sure that when the SQL Server cluster fails over to another node, that node also has the correct security information.

Note Any future changes that affect the membership of these groups must be manually updated on the remaining inactive SQL Server cluster nodes.

Keywords: kbhowto kbinfo KB935191

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.