Security Manager Service Pack - MSDTC Error (NETIQKB71176)

  • Document ID:7771176
  • Creation Date:31-Jul-2008
  • Modified Date:11-Aug-2008
    • Micro Focus Products:
      Security Manager

Environment

Security Manager 6
Service Pack 1
Security Manager 6 SP1
Service Pack 2
Security Manager 6 SP2
Service Pack 3
Security Manager 6 SP3
MSDTC Error

Situation

While installing Service Packs in Security Manager 6.0, there is an MSDTC error.

MSDTC Configuration issue

Resolution

Section 1 - Confirm MSDTC settings

Check the MSDTC settings on the Central Computer and the SQL Server. See the following Steps:

  1. Click on: Start > All Programs > Administrative Tools > Component Services.
  2. Inside Component Service expand: Component Service > Computers > My Computer.
  3. Right click on My Computer and click on properties.
  4. Select the MSDTC Tab and click on Security Configuration, in the bottom left corner.
  5. Inside Security Configuration window select the following:
  • Allow remote Clients,
  • Allow Remote Administration
  • Allow Inbound
  • Allow Outbound
  • No Authentication Required
  • Enable XA Translations.

    6.  Click ok at the bottom and then ok on the My Computer Properties Window.

Section 2 - Server cloning issue.

Restart MSDTC on the Central Computer and the SQL Server then check the Application Log on both servers for Event ID 4101. This event details the following data:
 
 
The local MS DTC detected that the MS DTC on %1 has the same unique identity as the local MS DTC. This means that the two MS DTC will not be able to communicate with each other. This problem typically occurs if one of the systems were cloned using unsupported cloning tools. MS DTC requires that the systems be cloned using supported cloning tools such as SYSPREP. Running 'msdtc -uninstall' and then 'msdtc -install' from the command prompt will fix the problem. Note: Running 'msdtc -uninstall' will result in the system losing all MS DTC configuration information.%0
 
If you receive this event the follow steps will resolve the issue:
 
  1. Log into the Central Computer with an administrative account.
  2. Click on: Start > Run.
  3. In the Run box type in CMD and click ok.
  4. Inside the Command Window type the following: msdtc - uninstall
  5. Click on Start > Administrative Tool > Services.
  6. Verify that the Distributed Transaction Coordinator is disabled. You may need to allow a couple minutes for the uninstall process to complete.
  7. After verifying that the uninstall is complete, type the following command in the Command Window: msdtc - install.
  8. In the service menu, verify that the Distributed Transaction Coordinator is Enabled. You may need to allow a couple minutes for the install process to complete.
  9. Reboot the server.
Repeat Steps 2 through 9 on the SQL Server.

Cause

MSDTC is misconfigured on the Central Computer and/or the SQL Server containing the Onepoint database.

Additional Information

Formerly known as NETIQKB71176