Microsoft KB Archive/810910

= HOW TO: Cluster Microsoft BizTalk Adapter for SQL Server on Windows 2000 Advanced Server =

Article ID: 810910

Article Last Modified on 10/29/2007

-

APPLIES TO


 * Microsoft BizTalk Adapter for SQL

-



IN THIS TASK

 * SUMMARY
 * Requirements
 * Install BizTalk Adapter for SQL Server on the Cluster Nodes
 * Add a Cluster Resource for the BizTalk Adapter for SQL Server Service
 * Add a Cluster Resource for the BizTalk Adapter for SQL Server AIC COM+ Application
 * REFERENCES



SUMMARY
This step-by-step article describes how to install Microsoft BizTalk Adapter for SQL Server in a Microsoft Cluster Service (MSCS) configuration.

back to the top

Requirements
This article assumes that you are familiar with the following topic:

Installation and configuration of Microsoft BizTalk Server 2002 on a Microsoft Cluster server computer

back to the top

Install BizTalk Adapter for SQL Server on the Cluster Nodes
You must install BizTalk Adapter for SQL Server on each node that is in the cluster. To install the adapter on the first node in the cluster, follow these steps:
 * 1) Make the computer where you are going to install BizTalk Server Adapter for SQL Server the owner of the group that contains the BizTalk Messaging resources. If there is more than one resource group, use the resource group that contains MSDTC.
 * 2) Install BizTalk Adapter for SQL Server on the cluster node that owns the group that contains the BizTalk Messaging resources.
 * 3) In Control Panel, double-click Services. In Services, configure the BizTalk Adapter for SQL Server service to start manually and set Log On to the same account that the BizTalk Messaging Service is configured to log on as.

When one node has control over the BizTalk Adapter for SQL Server resource, the BizTalk Adapter for SQL Server service runs on that node. If the first node fails over to the second node, the service on the first node stops and the service on the second node starts automatically.
 * 1) Repeat steps 1 through 3 to install BizTalk Adapter for SQL Server on each node in the cluster.

back to the top

Add a Cluster Resource for the BizTalk Adapter for SQL Server Service
 Start Cluster Administrator on the cluster node that is currently the owner of the cluster group that contains the BizTalk Messaging resources. To do this, click Start, point to Programs, point to Administrative Tools, and then click Cluster Administrator. Right-click the cluster group that contains the BizTalk Messaging resources, click New, and then click Resource. Type BizTalk Adapter for SQL Server Service in the Name text box. In the Resource type list box, click Generic Service, and then click Next. Make each node a possible owner. To do this, add each node that appears in the Available nodes list to the Possible owners list. Click Next. Add a dependency for the BizTalk Messaging Service resource. To do this, add the BizTalk Messaging Service resource that appears in the Available resources list to the Resource dependencies list. Click Next. In the Service name text box, type RFSQL. In the Start parameters text box, type the path of the RFSQL.exe file. For example, type the following:

C:\Program Files\Microsoft BizTalk Adapter for SQL Server\RFSQL.exe

Click to select the User Network Name for computer name check box, and then click Next.</li> In the Registry Replication dialog box, type the following registry key:

<pre class="fixed_text">Software\Microsoft\BizTalk Adapter for SQL Server\Joblist

Click Finish.</li> Right-click the BizTalk Adapter for SQL Server Service resource that you created in steps 1 through 8, and then click Properties.</li> In Properties, click the Advanced tab.</li> On the Advanced tab, click to select the Do not restart check box, and then click OK.</li></ol>

back to the top

Add a Cluster Resource for the BizTalk Adapter for SQL Server AIC COM+ Application
<ol> Start Cluster Administrator on the cluster node that is currently the owner of the cluster group that contains the BizTalk Messaging resources.</li> Right-click the cluster group that contains the BizTalk Messaging resources, click New, and then click Resource.</li> In the Name text box, type BizTalk Adapter for SQL Server AIC .</li> In the Resource type list box, click Generic Service, and then click Next.</li> Make each node a possible owner, and then click Next.</li> Add a dependency for the BizTalk Adapter for SQL Server Service resource, and then click Next.</li> In the Generic Application Parameters dialog box, type the following value in the Command line text box:

dllhost.exe /ProcessID:{433B756B-591C-4AC6-BE7A-D76A804CA0DE}

</li> In the Current directory text box, type the root directory of the shared disk resource drive in the group. For example, type the following:

H:\

</li> Click to select the Allow application to interact with desktop check box and the Use Network Name for computer Name check box, and then click Next.</li> In the Registry Replication dialog box, click Finish.</li> Right-click the BizTalk Adapter for SQL Server AIC resource that you created in steps 1 through 10, and then click Properties.</li> In Properties, click the Advanced tab.</li> <li>On the Advanced tab, click to select the Do not restart check box, and then click OK.</li> <li>Configure the BizTalk Adapter for SQL Server COM+ application on each node in the cluster to run under the same identity that the BizTalk Messaging Service is configured to log on as, follow these steps: <ol style="list-style-type: lower-alpha;"> <li>Click Start, point to Programs, point to Administrative Tools, and then click Component Services to start the Component Services Microsoft Management Console (MMC).</li> <li>Expand Component Services, expand Computers, expand My Computer, expand COM+ Applications, right-click BizTalk Adapter for SQL Server, and then click Properties.</li> <li>In Properties, click the Identity tab.</li> <li>On the Identity tab, type the user name and the password of the account that the BizTalk Messaging Service is configured to log on as.</li></ol> </li> <li>Configure the BizTalk Adapter for SQL Server COM+ application on each node in the cluster to prevent the clustered BizTalk Adapter for SQL Server AIC resource from failing during periods of inactivity. To do this, follow these steps: <ol style="list-style-type: lower-alpha;"> <li>Start the Component Services MMC.</li> <li>Expand Component Services, expand Computers, expand My Computer, expand COM+ Applications, right-click BizTalk Adapter for SQL Server, and then click Properties.</li> <li>In Properties, click the Advanced tab.</li> <li>On the Advanced tab, click to select the Leave running when idle option under Server Process Shutdown, and then click OK.</li></ol> </li></ol>

back to the top

<div class="references_section">