How To Install an MSMQ Independent Client on a Cluster After SQL Server 7.0 (237458)



The information in this article applies to:

  • Microsoft Message Queue Server (MSMQ) 1.0
  • Microsoft Cluster Server
  • Microsoft SQL Server 7.0

This article was previously published under Q237458
IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows Registry

SUMMARY

If you try to install a Microsoft Message Queuing (also known as MSMQ) Independent Client (IC) or Routing Server (RS) on a Microsoft Cluster Server (MSCS) cluster where SQL Server 7.0 or later has been installed, the installation may fail because of incompatibilities with the Microsoft Distributed Transaction Coordinator (MS DTC) command-line syntax.

This article describes how to install an Message Queuing Independent Client or Routing Server on a cluster from the Microsoft Windows NT Server 4.0 Enterprise Edition component CD after you install Microsoft Windows NT 4.0 Service Pack 4 (SP4) or later, SQL Server 7.0, or SQL Server 7.0 Service Pack 1 (SP1).

MORE INFORMATION

WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

This method is made more difficult because of the changes that are made from Microsoft Distributed Transaction Coordinator (MS DTC) version 1.0 to MS DTC version 3.0. MS DTC 3.0 is included with SQL Server 7.0 or SQL Server 7.0 SP1 and is upgraded by Windows NT 4.0 SP4 or later.

The basic process is as follows:
  1. Remove MS DTC and its supporting dynamic-link libraries (DLLs).
  2. Install Microsoft Message Queuing.
  3. Upgrade from the older MS DTC that is installed with Message Queuing to the newer version of MS DTC that is included with SQL Server 7.0 or SQL Server 7.0 SP1 or is upgraded by Windows NT 4.0 SP4 or later.
The following sections provide more specific information about each of these steps. By following these steps, you can complete the Message Queuing installation successfully and create a fully functioning cluster with SQL Server 7.0 and Message Queuing.

NOTE: There is one error on each node for the Message Queuing installation. MS DTC returns a 0x424 error. However, the Message Queuing installation completes successfully.

Remove MS DTC and Its Supporting DLLs

  1. Stop the SQL Server resource and the SQL Server Agent resources in Cluster Administrator.
  2. Run the following command on node 1:

    msdtc -remove

  3. Run the following command on node 2:

    msdtc -remove

  4. Remove the MS DTC resource in the Cluster Resource group.

    NOTE: Do not remove the DTC IP and Network name resources; remove only the MS DTC resource itself.
  5. On each node, locate and then remove the following registry subkey:

    HKEY_LOCAL_MACHINE\Software\Microsoft\MSDTC

  6. On each node, delete any of the following files in the \%windir%\System32 folder:
    • Adme.dll
    • Dtcadmc.dll
    • Dtccfg.cpl
    • Dtccm.dll
    • Dtctrace.dll
    • Dtctrace.exe
    • Dtcuic.dll
    • Dtcuis.dll
    • Dtcutil.dll
    • Dtcxatm.dll
    • Dtcsetup.exe
    • Msdtc.dll
    • Msdtc.exe
    • Msdtcprx.dll
    • Msdtctm.dll
    • Msdtcw.exe

  7. Empty the Recycle Bin, and then restart both nodes.

Install Microsoft Message Queuing

  1. Move the resource group that contains SQL Server and that will contain MS DTC and Message Queuing to the node where SQL Server was first installed. This description refers to this node as node 1.
  2. Move the other resources to node 2.
  3. To install the Message Queuing Routing Server on node 1, run the Setup.exe program that is located in the \Msmq\Msmq\Server folder on the Microsoft Windows NT Server 4.0 Enterprise Edition Component CD.
  4. Setup.exe runs until a dialog box reports a 0x424 error for MS DTC. Click OK in this dialog box and any other dialog boxes that follow. (One dialog box indicates that Message Queuing was successfully installed.)
  5. During this installation process, click Custom, click to clear the installation share, and then click Routing Server. When you are prompted for the name of the Primary Site Controller, type the name of your Primary Site Controller or Primary Enterprise Controller.
  6. In the list of Internet Protocol (IP) addresses in the Connected Networks pane, click the IP address that is associated with this group. This is the address that Message Queuing uses to communicate with the other Message Queuing computers.
  7. In the Connected Network drop-down list box, click a connected network for this IP address, and then click Continue.

    NOTE: Do not assign a connected network to any other IP addresses in the list.
  8. When you receive the 0x424 error from MS DTC, click OK.
  9. When another dialog box indicates that MS DTC cannot be started, click Yes to continue.
  10. When you receive the "MSMQ successfully installed" message, click OK.
  11. Start Cluster Administrator, and then open the Properties page of the MS DTC resource.
  12. On the Advanced tab of the Properties dialog box, click to clear the Affect the group check box, and then click Apply. Notice that Cluster Administrator displays MS DTC in failed status and Message Queuing offline.
  13. Move this resource group to node 2. Move the other resources back to node 1.
  14. If Message Queuing is online, take it offline.
  15. Run the Message Queuing Setup on node 2. Notice that you receive the same 0x424 error from MS DTC. When you click OK, a dialog box confirms that Message Queuing is installed successfully.

    Other Message Queuing pane that request information should return the same answers that they returned on the first node installation.

Upgrade MS DTC

  1. Move the resource group back to node 1. Run Dtcsetup.exe from the SQL Server 7.0 CD (\x86\Other) on node 1. When you are prompted, run Dtcsetup.exe on node 2 before you click OK on the first node.
  2. In Cluster Administrator, right-click the MS DTC resource, and then click Dependencies. Add SQL Server back to this list. You can also click to select the Affect the group check box if you want.
  3. Bring MS DTC and Message Queuing online and fail them over.
  4. Place all of the resources on one node, and then apply Windows NT 4.0 SP4 or later to the node that does not have any owned resources.
  5. Restart the node that does not have any resources, and then move all of the resources to this node.
  6. Reapply Windows NT 4.0 SP4 or later to the other node, and then restart that node.

Modification Type:MinorLast Reviewed:7/2/2004
Keywords:kbDTC kbhowto KB237458