MSMQ Independent Client Installation on a Cluster SQL Server 7.0
- MS DTC and it’s DLL should be removed
- MS Message Queuing Installation
- MS DTC Upgration
Message Queuing Installation and Cluster Setup with SQL Server 7.0 and Message Queuing :
- SQL Server and SQL Server Agent should be stopped
- Run Command : msdtc -remove on Server1
- Run Command : msdtc -remove on Server2
- Remove MS DTC reource in Cluster Resource Group
- Locate and remove : HKEY_LOCAL_MACHINESoftwareMicrosoftMSDTC
- On each node, delete files in %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
- Reboot Nodes
MS Message Queuing Installation :
- Move SQL Server group that containts MS DTC and Message Queuing to Servers.
- Move all to Server2
- Message Queuing Routing Server Installation on Server1
- Run Setup.exe which is located in MsmqMsmqServer folder on MS Windows NT Server 4.0 Ent. Edition Component CD
- It will run until 0×424 error for MS DTC is reported.
- Click Ok
- While Installation, Click Customer and clear installation share and then click Route Server. When Primary Site Controller is prompted, type PSC name
- In IP Address list, click IP with group, this is required that Message Queuing that is used to communicate with other Message Queuing.
- In Connected Network drop-down, click connected network and Continue.
- When Error is seen, Click Ok
- Click Yes to continue when it shows MS DTC cannot start.
- At prompt of MSMQ installation, Click Ok
- Start Cluster Administrator, open Properties of MS DTC resource
- On Advanced, click clear Affect group and apply
- It will be seen that MS DTC service will be offline
- Move resource group to Server2 and other resource to Server1
- Message Queuing should be offline
- Run Message Queuing Setup on Server2.
MS DTC Upgration :
- Move resource group back to Server1
- Run Dtcsetup.exe from SQL Server 7.0 CD – x86Other on Server1
- Run Dtcsetup.exe on Server2 and click Ok on Server1
- In Cluster Administrator, Right-click MS DTC resource, click Dependencies.
- Add SQL Servers to the list.
- MS DTC and Message Queuing should be Online
- All resource should be on node and Windows NT 4.0 SP4 should be applied
- Server1 should be Restarted now and all resources should be moved
- Apply Windows NT 4.0 SP4 to Server1 and Restart Node
